Skip to content

Lars Domesjö's blog

Stuff

Month: May 2010

Posted on May 19, 2010

Removing all connections to a microsoft sql server

DECLARE @SQL VARCHAR(8000)

SELECT @SQL=COALESCE(@SQL,”)+’Kill ‘+CAST(spid AS VARCHAR(10))+ ‘; ‘
FROM sys.sysprocesses
WHERE DBID=DB_ID(‘DATABASE_NAME’)

EXEC(@SQL)

Search

Archives

  • October 2017
  • October 2016
  • February 2016
  • November 2013
  • December 2012
  • November 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • August 2011
  • June 2010
  • May 2010
  • March 2010
  • February 2010
  • November 2009
  • October 2009

Calendar

May 2010
M T W T F S S
« Mar   Jun »
 12
3456789
10111213141516
17181920212223
24252627282930
31  

Categories

Proudly powered by WordPress