View Single Post
Old 06-28-2007, 12:37 PM   #16
daninthemix
Knows Where the Search Button Is
 
Join Date: Jun 2007
Model: 7100
PIN: N/A
Carrier: Vodafone
Posts: 22
Default

Quote:
Originally Posted by hdawg View Post
You could re-attach them to the MSDE instance ... How to manage the SQL Server Desktop Engine (MSDE 2000) or SQL Server 2005 Express Edition by using the osql utility

I still think you'd be better off upgrading to 4.x and having it re-create a database for you that way.
I tried entering the following 3 commands into osql, as 1, 2, 3, and then all together separated by commas like so:

EXEC sp_attach_db @dbname = N'BESmgmt', @filename1 = N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\BESMgmt.mdf', @filename2 = N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\BESMgmtlog.ldf'

and absolutely NOTHING happened. It just went to the next numbered line. Bes Management still doesn't run.

Please help!!
Offline