The column datatype does not match up between the Alter Table window and the Table Details window. The datatype size is incorrect. This is occuring for all tables and occurance of the varchar(n) datatype.
Details window notes varchar(50) and other various sizes (i.e (10), (15), etc), but all varchars in the Alter window note varchar(10).
When trying to alter the values, the error "columns must be the same length and scale" is thrown.
Conflict in the App Data directory from installing Toad over previous install.
Reset application data directory.
1. Exit Toad
2. Go to C:\Documents and Settings\<user>\Application Data\Quest Software\Toad for SQL Server <version>
(Windows 7: C:\Users\$user$\AppData\Roaming\Quest Software\Toad for SQL Server <version>)
3. Rename the Toad for SQL Server <version> folder.
Start Toad and test the issue. When restarting Toad, do not choose to migrate settings.
This may apply to various versions of Toad for SQL Server.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy