Lee posted on February 11, 2009 09:18
Neat way blow users out of a database. Very nice!


Here's a handy script by Pinal Dave for killing all connections within a database in SQL Server. 

 

 

 
------------------------------


How many times has each of us written some version of this thing?

 

http://blog.sqlauthority.com/2006/12/01/sql-server-cursor-to-kill-all-process-in-database/


Posted in:   Tags:

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading




by Lee Everest, M.S.

Search


Ads

Calendar

«  July 2010  »
MoTuWeThFrSaSu
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2010 Lee Everest's SQL Server, etc. weblog