Adventureworks db

I installed adventureworks db onto sqlExpress. It does not show up althought it is in the:

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

I look up the database in the Microsoft SQL Server Management Studio Express, But it's not visible. I've turned the service off andon, but it still is not available. Any ideas what has happened.

john welte

The installation of the sample database does not mean that you attached it for use in SQL Server. You will need to use the sp_attach procedure or the command which can be found in Management Studio under Right click the Server > Attach Database > specify the location and the name of the database file > Done :-)

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de