When attaching database to MSDE receive error sp_db_attach not found
Posted on 2004-08-17
I don't know why I am getting the error sp_db_attach not found when trying to attach a database to MSDE. I have done it once in the past without any problems, but it has been a while and I can't seem to find the sample I used to do it. I type in the following at the C:\Prompt
1>EXEC sp_db_attach "dbname", "c:\path\db.mdf", "C:\path\db.ldf"
This is when I get the sp_db_attach not found. Know this is a simple problem, but I need immediate help.