Re: SQL 2005 dbo user issue
From: Gail Erickson [MS] (gaile_at_online.microsoft.com)
Date: 11/09/05
- Next message: Gail Erickson [MS]: "Re: VS 2005 - Server Explorer - Diagrams - Invalid DBO User"
- Previous message: Malcolm Klotz: "Re: Linked Servers"
- In reply to: Lazer: "Re: SQL 2005 dbo user issue"
- Next in thread: Sophie Guo [MSFT]: "Re: SQL 2005 dbo user issue"
- Reply: Sophie Guo [MSFT]: "Re: SQL 2005 dbo user issue"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 9 Nov 2005 12:19:04 -0800
While it may appear that the database diagram tool in SQL Server 2005 is the
same as the diagram tool in SQL Server 2000, it is not. The Database
Diagram tool in SQL Server 2005 uses supporting objects that require SQL
Server 2005 functionality. This is documented in the readme file that comes
with SQL Server 2005. Here's a bit of that text.
"To install database diagram support in SQL Server Management Studio,
databases must be in SQL Server 2005 database compatibility level. Database
compatibility level can be reset after diagram support is installed."
However, as Dan states, you cannot attach or restore a SQL 2005 database on
an instance of SQL 2000 regardless of the compatibility level of the
database.
-- Gail Erickson [MS] SQL Server Documentation Team This posting is provided "AS IS" with no warranties, and confers no rights "Lazer" <Lazer@discussions.microsoft.com> wrote in message news:901AA0BC-09A2-4714-B674-A82615CFDCCA@microsoft.com... > So there is no way for me to create a Database diagram on a SQL 2000 > database > using SQL Server management studio 2005 even though that database diagrams > is > not a new feature? > > Thanks > > > "Dan Guzman" wrote: > >> Although you can attach or restore a SQL 2000 database to SQL 2005, you >> can't go the other way regardless of the database compatibility level. >> To >> promote your SQL 2005 schema to SQL 2000, you'll need to generate and >> execute scripts (assuming you haven't used new SQL 2005 features). >> >> -- >> Hope this helps. >> >> Dan Guzman >> SQL Server MVP >> >> "Lazer" <Lazer@discussions.microsoft.com> wrote in message >> news:A3335E6F-4868-436A-98DF-480D43C06F2D@microsoft.com... >> >I got the same error and this issue really helped me >> > >> > But my question is still if I will change the compatibility level and >> > then >> > I >> > need to distribute this database to the production server using SQL >> > 2000 >> > server will it work? >> > >> > Thanks >> > >> > "TomT" wrote: >> > >> >> Sophie, >> >> >> >> Thanks. that did it the trick. I guess the error message I originally >> >> got >> >> needs to be changed to indicate the problem was with compatibility >> >> level, >> >> not >> >> db owner. >> >> >> >> thanks for your help. >> >> >> >> "Sophie Guo [MSFT]" wrote: >> >> >> >> > Hello Tom, >> >> > >> >> > Based on my further research, we can resolve the issue by setting >> >> > the >> >> > compatibility level to "SQL Server 2005 (90)". You can perform the >> >> > following steps to change the compatibility level: >> >> > >> >> > 1. Right-click the database in the Management Studio. >> >> > 2. Select Properties > Options > Compatibility level to "SQL Server >> >> > 2005 >> >> > (90)". >> >> > >> >> > I tested it on my side and it works fine. The cause is we can only >> >> > add >> >> > diagrams to a SQL Server 2005 database. I hope the information is >> >> > helpful. >> >> > >> >> > Sophie Guo >> >> > Microsoft Online Partner Support >> >> > >> >> > Get Secure! - www.microsoft.com/security >> >> > >> >> > ===================================================== >> >> > When responding to posts, please "Reply to Group" via your >> >> > newsreader >> >> > so >> >> > that others may learn and benefit from your issue. >> >> > ===================================================== >> >> > This posting is provided "AS IS" with no warranties, and confers no >> >> > rights. >> >> > >> >> > >> >> >>
- Next message: Gail Erickson [MS]: "Re: VS 2005 - Server Explorer - Diagrams - Invalid DBO User"
- Previous message: Malcolm Klotz: "Re: Linked Servers"
- In reply to: Lazer: "Re: SQL 2005 dbo user issue"
- Next in thread: Sophie Guo [MSFT]: "Re: SQL 2005 dbo user issue"
- Reply: Sophie Guo [MSFT]: "Re: SQL 2005 dbo user issue"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
