AdventureWorks does not show Database Diagrams

Question

I have 2008 SQL Server Express with Services, loaded AdventureWorks. I can not see the Database Diagram on any of the databases. The first time I double clicked on Database Diagram I got the message "The database does not have one or more of the support objects required to use database diagramming. Do you wish to create them?" I click on the affirmative button and nothing. Then when I double click on Database Diagram I get nothing. How can I see the Database Diagram?

BTW - when I tried to copy the message to the clip board I got "This message cannot be copied to the clipboard. Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it (System.Windows.Forms)." Any idea on this?


Thanks

Brenda G

Answer 1

I haven't a clue about the second error, but the database diagrams aren't there by default - you need to create them.  Alternatively, you can view an online version here: http://msftdbprodsamples.codeplex.com/Wiki/View.aspx?title=AWSchemaDiag&referringTitle=Home

HTH!

---

Aaron Alton | thehobt.blogspot.com

Answer 2

Howdy, TheBrenda. Aaron is correct, the database diagrams in SSMS are user-created; we don't ship those. We do ship diagrams in the installer in three different formats: VSD, PDF and PNG. These diagrams can be found in the same location with the AdventureWorks source files, which (by default) inside each of the databases' respective folders in %ProgramFiles%\Microsoft SQL Server\100\Tools\Samples\.

---

David Reed - MSFT - Microsoft Certified Architect|SQL Server - http://blogs.msdn.com/reedme/