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

We have all expanded the Database Diagram node in SQL Server Management Studio and see the dialog below. Click “Yes” to accept and go straight to reverse engineer the objects. Ever wondered what goes on beyond the scenes?

11-3-2016-11-32-35-am

The required objects to build Database Diagrams are not installed by default in a new database, including the sample databases. Listed below are the objects that are created, when we accept the offer to get them created.

Table
 dbo.sysdiagrams

Procedure(s)
 dbo.sp_upgraddiagrams
 dbo.sp_helpdiagrams
 dbo.sp_helpdiagramdefinition
 dbo.sp_creatediagram
 dbo.sp_renamediagram
 dbo.sp_alterdiagram
 dbo.sp_dropdiagram

Function(s)
 dbo.fn_diagramobjects

That’s it. Now you are all set to go ahead and create the ERD

Now the interesting question is how to find these objects 🙂 If so read this article to use the Profiler.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: