reverse engineering and user-defined data types

[twilightsilhouette]

I reverse engineered an SQL 2000 database into VISIO (need to create some auto-update scripts) and am receiving the following error for 13 different data types (eg: char, int, bit, timestamp, nchar, varchar, etc.):

"The user defined type name is a reserved word in the target DBMS"

Removing/Renaming/Deleting these user defined types is an option to fix the error but results in loss of customized data types in each column (say a column in a table should have been char(25) - well visio changes it to a char(8000)).

I can't update/generate any scripts on my modeled database until I resolve the errors. Any suggestions from SQL Server side of things?

 

[twilightsilhouette]

I fixed the errors by applying a patch from:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q286026

The SQL Server driver in Visio was thinking I was using SQL 7 and not 2000. The patch fixed this problem.