Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Copy across diagrams

Author  Topic 

jackstow
Posting Yak Master

160 Posts

Posted - 2002-04-05 : 09:03:45
Whenever I copy across a database from one server to another it never copies any diagrams. Is there a way to do this or a stored procedure that will recreate the diagrams?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-04-05 : 09:08:23
The diagram info is stored in the dtproperties table, I think (not sure though) that if you DTS this table over as well it should work.

Go to Top of Page
   

- Advertisement -