Home > Archive > MS SQL Server > October 2006 > RE: Database diagram in SQL Server 2005









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author RE: Database diagram in SQL Server 2005
Charles Wang[MSFT]

2006-10-28, 7:14 pm

Hi,

I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.

Have a great day!

Charles Wang
Microsoft Online Community Support

lund0529

2006-10-28, 7:14 pm

I have this same issue at the moment, and I am on compatibility level 90. I
have other databases on the same server for which I am able to use database
diagramming.

"Charles Wang[MSFT]" wrote:

> Hi,
>
> I am interested in this issue. Would you mind letting me know the result of
> the suggestions? If you need further assistance, feel free to let me know.
> I will be more than happy to be of assistance.
>
> Have a great day!
>
> Charles Wang
> Microsoft Online Community Support
>
>

lund0529

2006-10-28, 7:14 pm

I have the same issue. My database is set with compatibility level 90. I
have other databases in the same instance of SQL server for which I can use
database diagrams.

"Charles Wang[MSFT]" wrote:

> Hi,
>
> I am interested in this issue. Would you mind letting me know the result of
> the suggestions? If you need further assistance, feel free to let me know.
> I will be more than happy to be of assistance.
>
> Have a great day!
>
> Charles Wang
> Microsoft Online Community Support
>
>

Rolando

2006-10-31, 12:15 am

what i did to fix this was go to database your working with, go to
properties, click on FILES and then add the SA account to the owner... done!

"lund0529" wrote:
[color=darkred]
> I have the same issue. My database is set with compatibility level 90. I
> have other databases in the same instance of SQL server for which I can use
> database diagrams.
>
> "Charles Wang[MSFT]" wrote:
>
Dave

2006-10-31, 12:15 am

Thanks Charles.

Setting the compatibility level to 90 solved my problem.

Dave


"Charles Wang[MSFT]" <changliw@online.microsoft.com> wrote in message
news:PJRiU9N%23GHA.4432@TK2MSFTNGXA01.phx.gbl...
> Hi,
>
> I am interested in this issue. Would you mind letting me know the result
> of
> the suggestions? If you need further assistance, feel free to let me know.
> I will be more than happy to be of assistance.
>
> Have a great day!
>
> Charles Wang
> Microsoft Online Community Support
>



Charles Wang[MSFT]

2006-10-31, 12:15 am

Hi Dave,

Appreciate your update and response. I am glad to hear that the problem has
been fixed. If you have any other questions or concerns, please do not
hesitate to contact us. It is always our pleasure to be of assistance.

Have a nice day!

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.
====================
====================
==============

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com