November 13, 2007 at 8:07 pm
Greetings People
I have a 2005 instance with many 80 mode databases (due to legacy applications). My developers need access to database diagrams without changing the db compatibility mode for individual dbs. Is there any way I can provide this either within 2005 tools, or a third party product ?
Thanks in Advance
Adonia
November 14, 2007 at 9:40 am
There doesn't appear to be anything that prevents creating diagrams for an 8.0 database. Do the developers get an error when they try to open or create a diagram?
One change from SQL 2000 is that diagrams in SSMS can't be shared between users. The creator of a diagram is it's owner and the only users who can see it are the creator and any member of the db_owner role.
Greg
Greg
November 14, 2007 at 5:59 pm
Yes the developers do get an error message. I will post it tomorrow when I'm back onsite.
November 14, 2007 at 7:29 pm
You could use a tool like Visio or ERwin to generate the database diagrams and then save them off or print them to .pdf.
K. Brian Kelley
@kbriankelley
November 15, 2007 at 6:58 pm
The error message we get is:
Database diagram support objects cannot be installed because this database does not have a valid owner. Ton continue, first user the files page of the database properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
----The current owner of most of these dbs is "Sa" so I cannot understand the error message context.
Also thanks for the information about individual ownership of database diagrams and the tools that are available.
Thanks in Advance
Adonia
November 15, 2007 at 7:38 pm
I'm reading in a few other places that you need to set your database compatibility mode to 90 (SQL Server 2005). Is this possible?
K. Brian Kelley
@kbriankelley
October 2, 2008 at 4:08 am
Yes, it was help full for me
Alex
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply