I can create a data diagram and all is well and good. Life cannot be better
If I attempt to create a second diagram in the same database I can lay out my tables (or even just a single comment) and I can print and all appears good but!
When I go to save I get this message. How can I create two diagrams for one database?
TITLE: Microsoft SQL Server Management Studio
Cannot insert the value NULL into column 'diagram_id', table 'ReportData.dbo.sysdiagrams'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The 'sp_creatediagram' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. (.Net SqlClient Data Provider)
BUTTONS:
OK
You might want to try the SQL Tools General forum for this, as it doesn't seem to relate to SSIS.|||
Moving thread...
|||Which service pack is installed on the machine ? Where did you try to create the second diagram ?
Jens K. Suessmeyer
http://www.sqlserver2005.de
|||
check whether this helps u
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=357447&SiteID=1
Madhu
No comments:
Post a Comment