Sysdiagrams Error

Topics: Database Publishing Wizard
Oct 16, 2006 at 4:33 PM
Getting this error in 2005. Any Ideas?

Error: dbo.sysdiagrams, column 'name' is of type SysName. This type is currently not supported.
Oct 16, 2006 at 5:05 PM
Hey. First of all thanks for downloading and getting the ball rolling here in the forum.

Unfortunately, the Sysname data type isn't supported in the 0.1.0.0 release of the Database Publishing Wizard and the tool won't script out a DB with types it doesn't support.

Possible workaround:
The sysdiagrams table is used by some tools to store table diagrams and it's pretty unlikely your app actually uses that table. One course of action here is to backup your DB and then remove the table from the DB as described here: http://weblogs.asp.net/andrewseven/archive/2006/08/10/Deleting-the-diagramming-objects-from-Sql-Server.aspx

Also, we'll be resolving this in the next CTP which should be out in a month.

Thanks,
Dan