 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / July 2008database diagram
Hi, I restored my database from the backup file, which is working fine but it is not showing the database diagram in SQL server management studio. What do I need to do for that? Thanks. Manj. Hi Manj, I understand that after you restored your database, you found that the database diagram disappeared in SQL Server Management Studio. If I have misunderstood, please let me know. Did you restore a SQL Server 2000 or earlier database to SQL Server 2005? If so, it is by design that the database diagram will not be displayed in SQL Server 2005 due to structure incompatibility. If your database is SQL Server 2005, the database diagram should be there in your restored database. Anyway for this issue, after you restore your database, you can manually create a diagram and add all of your tables to it. Please feel free to let me know if you have any other questions or concerns. Have a nice day! Best regards, Charles Wang Microsoft Online Community Support ===================================================== When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from this issue. ====================================================== This posting is provided "AS IS" with no warranties, and confers no rights. ====================================================== Hi Charles, Thanks for the reply. It is SQL Server 2005 database. When I click on database diagram I get the following message: TITLE: Microsoft SQL Server Management Studio ------------------------------ 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. ------------------------------ BUTTONS: OK ------------------------------ I added the owner from the Files page but still getting the same message. When I connect to the database it does show the owner in the 'owner box'. Cheers. Manj. > Hi Manj, > I understand that after you restored your database, you found that the [quoted text clipped - 23 lines] > This posting is provided "AS IS" with no warranties, and confers no rights. > ====================================================== Hi Manj, This is a known issue that was fixed in SP1 or SP2. When you upgrade a database from SQL Server 2000 to 2005, the database remains in 80 compatibility mode. To use the database diagram tool in SQL Server 2005, the database must be set to 90 mode. See this Books Online topic: http://msdn2.microsoft.com/en-us/library/ms186345.aspx  SignatureGail Erickson [MS] SQL Server Documentation Team This posting is provided "AS IS" with no warranties, and confers no rights Download the latest version of Books Online from http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx > Hi Charles, > [quoted text clipped - 51 lines] >> rights. >> ====================================================== Hi Gail, Thanks for the suggestion. Resolved the issue. Manj. > Hi Manj, > [quoted text clipped - 58 lines] > >> rights. > >> ====================================================== Hi all, I have the same problem (SS2005): TITLE: Microsoft SQL Server Management Studio ------------------------------ 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. With: SELECT USER it returns "dbo" Where the problem? Thanks a lot. Luigi The problem seems to be that the SID for your dbo user inside the database doesn't exist as a login in the master database. Use either ALTER AUTHORIZATION (as suggested by the error message) or sp_changedbowner to make sure that the database has an owner that really exist in the master database (as a login). SignatureTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi > Hi all, > I have the same problem (SS2005): [quoted text clipped - 19 lines] > > Luigi > The problem seems to be that the SID for your dbo user inside the database doesn't exist as a login > in the master database. Use either ALTER AUTHORIZATION (as suggested by the error message) or > sp_changedbowner to make sure that the database has an owner that really exist in the master > database (as a login). Thank you Tibor, I'll make in this way. Luigi Hi Charles, I have restored a backup of my SQL Server 2000 DB on to my SQL Server 2005 DB through the Management studio, I was able to fix the Authorization issue by simply changing the DB option to SQL Server2005(90), but now when I try to right click and create a new Database diagram it throws an error saying the module is not installed, what could be the cause for this error? Thanks Rastha G Hi Rastha, Please simply have a new post at the community so that we can better track the issue status and assist you more dedicatedly. Thank you for your cooperation. Have a nice day! Best regards, Charles Wang Microsoft Online Community Support ========================================================= Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: msdnmg@microsoft.com. ========================================================= SignatureThis posting is provided "AS IS" with no warranties, and confers no rights. ========================================================= |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.