itsme

Hello

I am a novice in using SQL Server 2000 enterprise edition

I am trying to copy a Database (through scripting) which has relationships I
created using Diagram.

When take this generated script and run on destination server, I do NOT see
any diagram under newly created DB.

Is there a way to do it?

Please help

allan mitchell

Providing all the tables and relationships are in the new database then look at this

http://www.mssqlserver.com/faq/transfer-diagrams.asp


--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
http://www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

dinesh.t.k

Hi,

HOW TO: Move a Database Diagram
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q320125


--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com