Example Databases

Hello Everyone:

I am testing SQL Sever Express and I would like to know how to load the adventure works databaes into SQL server? I have downloaded the files in accordance to the instructions providered however, when I open SQL Server the Adventure Works database does not appear. How do I add the adventure works database to my instance of SQL Server? It appears that the files downloaded correclty and teh setup executed correclty, and the database files can be found in my control panel.

Thanks

John

I see what you mean one thing Microsoft did not include was the installer just put the MDF and LDF in the data subfolder in Microsoft SQL Server in programs you have to attach it before you can use it. So locate the file in the location below and either use the wizard with right click in databases in Management Studio or modify the code in the link below and attach it. Then wait a little while and check your databases to make sure it is there. Post again if you still need help. If you did not find it in the location below then check in samples under 90 in Microsoft SQL Server folder.

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

http://msdn2.microsoft.com/en-us/library/ms165673.aspx