Can't detatch user instance

Discussion in 'ASP .Net' started by ad, Mar 23, 2006.

  1. ad

    ad Guest

    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
    ad, Mar 23, 2006
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page