Database Diagrams questions

  • We've recently purchased a software package, which comes with its own SQL Server 2005 database. I'm curious to know how the tables all fit together, and so I've thought I would generate a database diagram from the Database Diagrams folder. When I attempt to, I get the following message from SSMS:

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

    I'm not sure if I should say yes, or no, so I normally say no. However, I would think this wouldn't matter if I did say yes. So my question is, does it do any "harm" to answer Yes to the above question?

    Kindest Regards, Rod Connect with me on LinkedIn.

  • I have never experienced any harm by answering yes.

  • Thank you, Jack.

    Kindest Regards, Rod Connect with me on LinkedIn.

  • All you're doing by answering "yes" is creating the system tables and stored procedures needed to create and maintain diagrams, so you shouldn't expect any harm.

    Greg

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply