Home Forums Article Discussions Article Discussions by Author Discuss content posted by ashokjanjani Kill All User Sessions RE: Kill All User Sessions
rajdaksha
Grasshopper
Points: 17
More actions
December 7, 2009 at 1:00 am
#1088397
DECLARE @SQL VARCHAR(8000)
SELECT @SQL=COALESCE(@SQL, '') + 'KILL ' + CAST(SPID AS VARCHAR(10)) + '; '
FROM SYS.SYSPROCESSES
SELECT @SQL
EXEC(@SQL)