MS-SQL Server
Wednesday, May 13, 2009
get sleeping process from sql
SELECT 'KILL ' + CONVERT (char(3),spid) FROM master.dbo.sysprocesses
where dbid = (select db_id('Northwind'))
and status = 'sleeping'
GO
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
Blog Archive
January
(1)
January
(1)
June
(1)
November
(1)
May
(1)
March
(1)
February
(1)
December
(3)
November
(4)
October
(1)
September
(1)
August
(2)
July
(6)
May
(2)
August
(1)
July
(6)
October
(1)