Tuesday, March 20, 2012

Adventure Works DB Samples with Express 2005 SQL Server

Downloaded the file for the Adventure Works DB Sample. Which folder do I need to install it in to have show up in SQL Server Express 2005?

You can put it in any folder you want to (normally in the usual data folder you are using, by default this is located somehwere in the programe files , microsoft SQL Server directory. But you have to attach the database using the sp_attachdb procedure or use the GUI to attach the database, right click on the server --> attach database and you are done.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||You can attach DB's in the Management Studio Express then?|||Should be able to, right click on the Databases folder, if it is not listed try All Tasks|||did you get this to work ?I have attached the database and still could not get the report designer towork with the database.

No comments:

Post a Comment