How to kill all connections

  • Thread starter Thread starter ad
  • Start date Start date
A

ad

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?
 
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.
__________________________________
 
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
 
Back
Top