Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ejarju
Starting Member
1 Post |
 Posted - 2008-05-26 : 17:51:11
|
| Hi I had earlier installed a SQL 2000 personal Edition and with it I also installed a database called AdventureWorks, that I was using along with a Book on Beginning T-SQL. Today I uninstalled the personal edition to install SQL 2000 Developer edition to work on Reporting Services. I install personal edition and installed the developer edition. When I started the enterprise manager, I could not see the AdventureWorks database. I reinstalled it several times but still cannot see it come up in the enterprise manager nor in the data analyzer. I can see that the database files -mdf and ldf - has installed ok in the directory C:\Program Files\Microsoft SQL Server\MSSQL\Data but i cannot still see the database in enterprise manager. It apprears as if enterprise manager is looking at a different folder. Can someone please help? Much appreciated.regardsEdi |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-26 : 20:54:16
|
| If AdventureWorks' files are still on disk, you can attach them with sp_attach_db. |
 |
|
|
|
|
|
Cannot see the installed database