Creating diagrams using SQL?

[SQLnewcommer]

Hello,
I need to create a hard copy of my data warehouse design for a report.
I looked at the following website and really like the way they did it.. But I do not know how they did it. Could you give me some information about it.

http://www.windowsitpro.com/Files/09/8563/Screen_02.gif

If you think this is not a good idea please suggest a good method to do this.

 

[SQLDenis]

The picture is a SQL Server diagram
it is avaliable in enterprise manager under each database

You could also take a look at Visio or ERWin

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLnewcommer]

Thanks for the info. But can you give me more details on how to access the Server diagram? I have finished creating and populating my data warehouse. So is the Server diagram automatically created? How do I access it?

 

[jbenson001]

The diagram is not created automatially. Open enerprise manager. Drill down to the database. Click on Diagrams. Then you can create a new diagram.

Jim

 

[SQLnewcommer]

Sorry so many questions but how do you "drill down to the database". There is a tree like structure to the left but it is empty.

 

[ShankarJ]

You have to register the Server first. Right click on the default "SQL Server Group" and register your server. After that you will be able to see all the databases in the server.