<< Native XML Web Services (HTTP endpoints)...deprecated for SQL 2008 | New Books Online available for January 2009 >>

Kill all connections in SQL Server

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?

del.icio.us Tags: Kill all connections in SQL Server,SQL Server 2005 sp3,SQL 2008,SQL Server blog,SQL Server Weblog

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

Posted in: Tags:

Actions: E-mail | Permalink | Comments (0) | Comment RSS RSS comment feed

RSS comment feed

| E-mail | Kick it! | DZone it! | del.icio.us

0b25a15c-2cd2-4c98-95b2-df0775b71f0a|0|.0

Related posts

sp_executesql string size in SQL Server 2005, 2008Larger string size now for sure, but how long can it be?Get ready for some really great stuffI’m fas...The Mysterious and Subliminal Cascade Deletes in SQL ServerI was geeking last weekend, no wait, actually three weeks ago, and then last night and tonight…it do...Connect to SQL Server Compact Edition (SQL Server CE) using SSIS tasks Someone here at work is going to use SQL Server Compact Edition (SQL CE) to do some data sto...

blog comments powered by Disqus

by Lee Everest, M.S.

Info

Poll

Do you use Azure or cloud in your organization?

Yes
No
Hell no
Show Results

Ads

Search

Month List

1932
- January (1)
2006
- April (1)
- November (1)
- December (1)
2007
- July (3)
- August (4)
- December (2)
2008
- January (8)
- February (4)
- March (5)
- April (1)
- May (1)
- June (2)
- July (2)
- September (1)
- October (1)
- November (4)
- December (6)
2009
- January (7)
- February (6)
- March (9)
- April (7)
- May (9)
- June (11)
- July (9)
- August (14)
- September (14)
- October (14)
- November (14)
- December (14)
2010
- January (15)
- February (16)
- March (17)
- April (16)
- May (15)
- June (14)
- July (14)
- August (13)
- September (12)
- October (13)
- November (14)
- December (12)
2011
- January (16)
- February (14)
- March (12)
- April (11)
- May (13)
- June (16)
- July (12)
- August (12)
- September (9)
- October (9)
- November (15)
- December (12)
2012
- January (19)
- February (4)

Calendar

View posts in large calendar

Tags

OPML

Download OPML file

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 2012 Lee Everest's SQL Server, etc. weblog