Franklin,

If your looking for a hardcopy diagram, expand the database, right
click "diagram" and select "New Database Diagram" and follow the Wizard
to select tables and create the diagram. Note, this can use a lot of
paper and be very confusing if database is on the large size.

If you are looking for the DDL script, right click databse, select "All
Tasks" then select "Generate SQL Script" check the boxes to script the
objects you want, Preview script, copy to clipboard, paste in Notepad
document then save and print document.

S. Davey (5/30)


MI DIT\Agency Services
7:30 A.M. - 4:00 P.M. ET
517.335.4237 (M- F CCC )


>>> "Franklin Khachi "
<mssqldba-ezmlmshield-x77403364.[Email address protected] 05/29/07
6:26 PM >>>
Hi group,

I need your help with printing the data base schema and tables from my
SQL server 2000 data base please

Thank you guys

Franklin



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page