Lee posted on February 11, 2009 07: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:
Comments are closed

by Lee Everest, M.S.

Search


Ads

Calendar

«  March 2010  »
MoTuWeThFrSaSu
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234
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