Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

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
0
kennmurrah
Asked:
kennmurrah
1 Solution
 
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now