Groups | Blog | Home
all groups > sql server (microsoft) > december 2006 >

sql server (microsoft) : Where is AdventureWorks in 2005?


brett
12/19/2006 11:53:46 AM
I've installed the Developer edition of SQL Server 2005. The sample
databases were selected. When I loaded management studio, I don't see
the AdventureWorks database. I did a search on the hard drive and
nothing came up except something related to reporting in a templates
folder. No MDF files though.

Any suggestions on how I can it installed?

Thanks,
Brett
jebuskrust NO[at]SPAM gmail.com
12/19/2006 11:57:44 AM
http://www.microsoft.com/downloads/details.aspx?FamilyID=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

There ya go! :D
[quoted text, click to view]
brett
12/20/2006 9:59:54 AM
Perfect. Thanks.
brett
12/20/2006 9:35:49 PM
I've attached the AdventureWorks db but get this message when I go to
diagrams in Management Studio:

Database diagram support objects cannot be installed because this
database does not have a valid owner. To continue, first use the Files
page of the Database Properties dialog box or the ALTER AUTHORIZATION
statement to set the database owner to a valid login, then add the
database diagram support objects.

There is a valid owner (my windows login). How do I add the diagram
support objects?

Thanks,
Brett
AddThis Social Bookmark Button