Re: SQL 2005 dbo user issue
From: Sophie Guo [MSFT] (v-sguo_at_online.microsoft.com)
Date: 11/07/05
- Next message: Roy Goldhammer: "Changing Table Owner and user Owner"
- Previous message: Jim Underwood: "Re: mission impossible: How to protect a Sql Server (with VB.NET) from somebody who as administrator rights?"
- Maybe in reply to: Kalen Delaney: "Re: SQL 2005 dbo user issue"
- Next in thread: Dan Guzman: "Re: SQL 2005 dbo user issue"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 07 Nov 2005 07:21:43 GMT
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: Roy Goldhammer: "Changing Table Owner and user Owner"
- Previous message: Jim Underwood: "Re: mission impossible: How to protect a Sql Server (with VB.NET) from somebody who as administrator rights?"
- Maybe in reply to: Kalen Delaney: "Re: SQL 2005 dbo user issue"
- Next in thread: Dan Guzman: "Re: SQL 2005 dbo user issue"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
