-
Title
Alter Table not showing correct column lengths. "Columns must be the same length and scale" is th -
Description
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.
-
Cause
Conflict in the App Data directory from installing Toad over previous install.
-
Resolution
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.
-
Additional Information
This may apply to various versions of Toad for SQL Server.