Adventureworks with SQL Server 2008 Express RRS feed

  • Question

  • Does anyone know how I can attach the AdventureWorks2008 to my server instance? I get an error that it is looking for the documents folder in default directory for the regular edition of SQL Server 2008...MSSQL10.MSSQLSERVER\MSSQL\DATA insead of the default for Express edition...MSSQL10.SQLEXPRESS\MSSQL\DATA. When I try to attach it I get a file activation error saying that the location could not be found for ...MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents. I could not find a copy of this sample database for SQL Express 2008.
    Thank you,
    Thursday, February 18, 2010 2:19 AM


All replies

  • The Microsoft example databases are now on CodePlex: http://msftdbprodsamples.codeplex.com/ 

    Are you using the SQL Server management studio? If not, get it because you will need it for the manual. (listed in the SQL Server 2008 express editions-section)

    Here is a manual on installing the sample database.
    Dimitri C. - Please mark the replies as answers if they help! Thanks.
    • Proposed as answer by Dimitri C Wednesday, February 24, 2010 7:26 AM
    • Marked as answer by Rubel Khan Thursday, February 25, 2010 7:06 PM
    Friday, February 19, 2010 12:52 PM
  • Yes, I'm using the management studio. Thank you for the link. All the data bases work and now I can start studying. 
    Tuesday, February 23, 2010 1:29 AM