Diagram in SQL2008 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Diagram in SQL2008

Author

Topic

messi
Starting Member

47 Posts

Posted - 2009-03-21 : 16:02:22

when i try to open database digrames

in SQL20008 i recive this message :

http://www.4shared.com/file/94184989/7060bb5d/_2__untitled.html

any one help

cshah1
Constraint Violating Yak Guru

347 Posts

Posted - 2009-03-21 : 20:39:11

I do not have SQL 2008 at this moment (in front of me) but the following should work

1. Right Click on your database, choose properties

2. Goto the Options Page

3. In the Dropdown at right labeled "Compatibility Level" choose "SQL Server 2008(100)

4. Goto the Files Page

5. Enter "sa" in the owner textbox (OR in query editor type in

ALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"
go

6. Hit OK

messi
Starting Member

47 Posts

Posted - 2009-03-22 : 15:43:30

Thanks for your replay
i will try it ...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources