can't create db diagram - 2

i assume that i've got some kind of restrictions here. I can't create diagrams, i don't even have a place to start from. When i right click on "Database diagrams" i get only "working with SQL 2000 diagrams" and "Refresh". No "New".

So my real question is - probably nobody can fix that, i just have to have an idea why it's happening. What kind of restrictions it can be. This way I can be reasonably tough with our admin :)

p.s. oh yeah, i have a SQL 2005 server management studio open.

Are you hitting a SQL Server 2000 server from 2K5 tools or the other way around? They are a bit different.

If you are using 2K5, make sure the database is set to the 9.0 compatibility level. It might be set to 8.0 if you brought it over from SQL Server 2K.

There's more here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vdbref/html/dvhowcreatingdatabasediagram.asp

|||

Buck Woody - MSFT wrote:

Are you hitting a SQL Server 2000 server from 2K5 tools or the other way around? They are a bit different.

If you are using 2K5, make sure the database is set to the 9.0 compatibility level. It might be set to 8.0 if you brought it over from SQL Server 2K.

There's more here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vdbref/html/dvhowcreatingdatabasediagram.asp

other way around MS Server 2000 (data) from MS Server Management Studio

and yes, it sits on 80 - Thanks! I'll do changing right now.