Database diagrams | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database diagrams

Hi, Can anyone tell me where the database diagrams in SQL Server 2005 that were present in SQL Server 2000 gone? I cannot find the diagrams under the diagram pane. However everything else like DTS packages which is now SSIS in SQL Server 2005 is present. Even the taskpad has gone missing ? Thanks, StarWarsBigBang
Hi,
Open SSMS –>connect to your server–>Expand SQL Server–>Expand Database–>Select your database and expand–>You will see Database Diagrams folder, expand it and you will see all diagrams created
http://www.devx.com/dbzone/Article/31733 fyi in addition to above. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
apparently you can bring the taskpad back if you install SP2 via a custom report (I haven’t tried it though): http://sqlblogcasts.com/blogs/sqldb…s-in-sp2-enterprise-manager-taskpad-view.aspx www.elsasoft.org

My question remains unanswered. I had done the following : 1. Loaded SQL Server 2005 on my server.
2. Taken backup of my SQL server 2000 databases.
3. Reloaded the database dumps to SQL Server 2005. I cannot see the database diagrams. The owner for the database is ‘sa’ however I still get the message that the owner is invalid for the database.
Any input is appreciated in this matter.
Thanks, StarWarsBigBang
Have you tried changing the database owner to SA again? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Yes I have tried this. I get the following error message : ‘Database diagram support objects cannot be installed because this database does not have a valid owner. To continue first use 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’ Thanks, StarWarsBigBang
EXEC sp_dbcmptlevel database_name, 90 as perhttp://support.microsoft.com/default.aspx?scid=kb;en-us;910228 Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>