|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How to kill all connectionsI want to move the database files to another by program, but if the
connection is open, I can't do that? Can I kill all connections of a databse by program? If you use the SQL Management Studio Detach task, it gives you the option to
close the connections prior to detach. ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d0de0639-bc54-464e-98b1-6af22a27eb86.htm -- Show quote____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ "ad" <fly***@wfes.tcc.edu.tw> wrote in message news:e8fIu94TGHA.5836@TK2MSFTNGP10.phx.gbl... >I want to move the database files to another by program, but if the >connection is open, I can't do that? > Can I kill all connections of a databse by program? > Bill,
This is in my opinion a typical MS Assecc question where the extra file is pending. Probably you know the answer direct, while I have to search because I forgot it. Cor Show quote "William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> schreef in bericht news:eBRubc8TGHA.4276@TK2MSFTNGP10.phx.gbl... > If you use the SQL Management Studio Detach task, it gives you the option > to close the connections prior to detach. > > ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d0de0639-bc54-464e-98b1-6af22a27eb86.htm > > > -- > ____________________________________ > William (Bill) Vaughn > Author, Mentor, Consultant > Microsoft MVP > INETA Speaker > www.betav.com/blog/billva > www.betav.com > Please reply only to the newsgroup so that others can benefit. > This posting is provided "AS IS" with no warranties, and confers no > rights. > __________________________________ > > "ad" <fly***@wfes.tcc.edu.tw> wrote in message > news:e8fIu94TGHA.5836@TK2MSFTNGP10.phx.gbl... >>I want to move the database files to another by program, but if the >>connection is open, I can't do that? >> Can I kill all connections of a databse by program? >> > > Depends on the back end db you're using. Is there a specific one you need.
Show quote "ad" <fly***@wfes.tcc.edu.tw> wrote in message news:e8fIu94TGHA.5836@TK2MSFTNGP10.phx.gbl... >I want to move the database files to another by program, but if the >connection is open, I can't do that? > Can I kill all connections of a databse by program? >  |
|||||||||||||||||||||||
Other interesting topics