title: Detach SQL DB accessed in multiple processes
body: <p>I have a set of programs (consider parent and child processes) that access the same SQL database.  It is attached and detached during the course of the program(s).  I am having trouble only when I try and detach it when both processes have accessed it.  The connections are all closed, but if I try to execute the sp_detach stored procedure, I get an error message that it is in use and cannot be detached.  Is there something about the multi-process access that I need to address?</p>