Can't detatch user instance

A

ad

I use a .mdf file as user instance of my Web Application.
The file is c:\mydb.mdf
I connect the .mdf file with AttachDBFile, and then I want to detach the
file, I use the stored procedure:
sp_detach_db 'c:\mydb.mdf'
But the system error with message: can't detach the file, the file is used.

How can I detach a user instance with asp.net?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Staff online

Members online

Forum statistics

Threads
473,767
Messages
2,569,571
Members
45,045
Latest member
DRCM

Latest Threads

Top