Saturday, February 19, 2011

SQL Command Add Database Diagramming

Is there a tsql command on sqlserver 2008 which can be run in order to enable Database Diagramming instead of this dialog appearing:

This database does not have one or more of the support objects required to use database diagramming. Do you wish to create them?

From stackoverflow
  • The script is a little too long to add here, but here's what you can do. 1) Create a new database. 2) Start sql server profiler 3) Click the "Database Diagrams" folder in management studio. 4) Clear the profiler. 5) Confirm the message box with a prompt to enable diagramming. 6) Profiler now contains the script that enabled diagramming. 7) Select the script in profiler and copy the output from the bottom pane.

    Kim

    Tim Howland : devious, I love it!

0 comments:

Post a Comment