Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database diagrams Expand / Collapse
Author
Message
Posted Friday, February 26, 2010 4:30 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, April 07, 2014 10:25 AM
Points: 715, Visits: 1,018
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
Posted Friday, February 26, 2010 9:51 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:32 AM
Points: 4,056, Visits: 5,182
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
Posted Monday, March 01, 2010 9:22 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, April 07, 2014 10:25 AM
Points: 715, Visits: 1,018
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
Posted Monday, March 01, 2010 2:19 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 8:32 AM
Points: 4,056, Visits: 5,182
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 »

Add to briefcase

Permissions Expand / Collapse