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

Similar Threads

How to disconnect to an user instance database 0
Problem with "locked" SQL Server Express database files - Please help! 5
Update-database shows provider: SNI_PN11, error: 26 - error locating server/instance specified error 0
connectionstring and user Instance 2
Using Login control. In prod server, Need to attach App_Data mdffiles to database. Help. 0
My code appears to fail to detach the DB 4
Please help: steps to go from SQL Express and SQL 2005 Production 4
Strange DB names in a User Instance 0

Members online

No members online now.
Total: 390 (members: 0, guests: 390)
Robots: 423

Forum statistics

Threads
474,431
Messages
2,571,677
Members
48,796
Latest member
Greg L.

Latest Threads

Top