Post reply

Error 5123

  • July 27, 2005 at 10:16 am

    #110156

    I'm getting Error 5123 "Cannot open because file is being used by another process" when I try re-attaching a database (.mdf) I just detached. 

    I'm afraid I issued a DBCC command (which may be locking the file) right before I detached the DB.  DBCC OPENTRAN (oldoaiapp)

    Does anyone know how I can identify and kill whatever process is attached to my .mdf database?  I obviously cannot use Query Analyzer as I cannot see the database anymore.

    Thanks,

    Leslie

  • July 27, 2005 at 10:59 am

    #577634

    Please do not cross post. Most of us check all forums and if you cross post answers and information are likely to get split up between the multiple threads. See my reply here:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=204995

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply