can't attach database in SQL Server 2000, says it's in use

Okay, I can see my database but it has become unattached from SQL.  I tried to attach it, but it says it's in use by another person or program.  Rebooting didn't help.  Also tried to stop SQL services and copy file .. .same error.  Any ideas?

thanks in advance.

kennM
kennmurrahAsked:
Who is Participating?
 
Peter HutchisonSenior Network Systems SpecialistCommented:
Refresh the display in Enterprise Manager and then check each of the database properties to check that it hasn't already been attached as a different database name.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.