Database diagrams

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Database diagrams

Database diagrams

Rate Topic

Display Mode

Topic Options

Author

Message

river1

Posted Friday, February 26, 2010 4:30 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

Hi,

Every time i try to do a database diagram i receive an error massage that says the following:

This database does not have one or more of the supporte objects require to use database diagram.
Do you want to install them?

What database objects are this? i don't know if i can install them or not....

Thank you

Post #873321

Greg Charles

Posted Friday, February 26, 2010 9:51 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:08 PM
Points: 4,006, Visits: 4,845

The objects are dbo.sysdiagrams, dbo.upgraddiagrams, dbo.helpdiagrams, dbo.helpdiagramdefinition,dbo.sp_creatediagram, dbo.sp_renamediagram, dbo.sp_alterdiagram, and dbo.sp_dropdiagram.

They're created when a member of syadmin or a member of db_owner answers yes to the install question. If you're a member of one of the aforementioned roles, you can create them.

Greg

Post #873558

river1

Posted Monday, March 01, 2010 9:22 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

Thank you Greg.

AFTER you responde yes (if you are member of sysadmim or DB_onwer), then people can start create Diagramms because the objects are created.

1- Where are the objects created? are they all created in the Master database? or are they created in the User database where i reply with a yes?

2- AFTER a member of the sysadmin or DB_owner responde yes, who can create diagramms? only persons belonging to this two roles?

Thank you.

Post #874489

Greg Charles

Posted Monday, March 01, 2010 2:19 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:08 PM
Points: 4,006, Visits: 4,845

1- The objects are created in the current database, not master.
2- Any user with access to the database can create a diagram.

In addition, the diagram is only viewable by it's creator and by members of sysadmin and db_owner.

This is all documented in BOL under "diagrams [SQL Server]".

Greg

Post #874711

« Prev Topic | Next Topic »

Permissions