problem with Server Management Studio Express and diagrames

so I have had a database in Sql Server 2000, in my DB i have made database diagrams.

now I have installed on other PC(where does't install sql 2000) Sql Server Management Studio Express where I have opened my db , bat db diagrams does't work.

what can I do? how can I solve this problem?

enyone can explain me?

thanks.

Management Studio can't open SQL 2000 diagrams, if you click on the diagrams branch of the tree it should ask if you want to install diagram support, once this is done you can create new diagrams.|||ok, bat when I opend diagrams branch of the tree, it doesn't ask if I want or not to install diagram|||

hi,

usually you have to first import the database to the new SQL Server 2005 instance (as you already did)..

then modify the compatibility level to 90 via the SSMSE, database properties (options tab), and finally set the database owner to a valid principal, again SSMSE, database properties (files tab, "owner" peroperty )...

then you should be able to access database diagrams..

regards

Problem with printing database diagrams

When I print a database diagram directly, I get the top left corner obsrured on the printout by what looks like an empty popup box. This means the columns names are blanked out for the first 5-6 rows. I have tried this with a variety of printers and the effectis the same on all. The problem appears to be specific to SQL2005 as one of the servers has both SQL2000 and SQL2005. The disagrams from the SQL2000 print perfectly, the ones from SQL2005 do not.

SQL2005 has been patched to SP2.

I have circumvented the problem by writing an SSRS package to print the output of a stored procedure that emulates the database diagram. Also there is an option in SQL2005 database diagrams to get an image of the diagram. I have printed this in Word and it prints flawlessly that way.

I believe this is an unique problem you are facing and I think nothing much done from SQL dev. team.

See thsi http://www.codeproject.com/dotnet/ScriptDiagram2005.asp is any help and you can report the same to MS Connect website http://connect.microsoft.com/

|||Regrettably I still have the problem with diagram on SQL2005 (but SQL2000)
|||

This is not a unique problem.

I've been encountering it for a month or two.

It's intermittent. Sometimes the diagrams are okay, sometimes these boxes obscure fields.

My only work-around is to PRINT SCREEN and then copy it into Word and print it.

|||We are having this same problem. If you copy to Word it will print. Has there been a solution found yet?|||Copying to Word is a good work-around, but is not a solution. It did happen with all the printers I could try at that site.