Kill All User Sessions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by ashokjanjani » Kill All User Sessions

Kill All User Sessions

Rate Topic

Display Mode

Topic Options

Author

Message

ashokjanjani

Posted Sunday, September 23, 2007 2:33 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, December 15, 2003 12:00 AM
Points: 45, Visits: 1

Comments posted to this topic are about the item Kill All User Sessions

Post #401541

JOn-323586

Posted Sunday, December 16, 2007 9:40 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, May 04, 2013 9:59 PM
Points: 4, Visits: 396

I used a modifed version to block users from my database. Instead of using a cursor you can use...

declare @out nVarchar(4000)
SELECT @out = COALESCE (RTRIM(@out)+' Kill ' ,'')+ cast(spid as varchar(10))
from master..sysprocesses where db_name(dbid) = 'myDatabase' AND NT_USERNAME like @uid
set @out= 'kill ' + @out
execute sp_executesql @out

Post #433775

rajdaksha

Posted Monday, December 07, 2009 1:00 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 7:25 AM
Points: 1, Visits: 93

DECLARE @SQL VARCHAR(8000)

SELECT @SQL = COALESCE(@SQL, '') + 'KILL ' + CAST(SPID AS VARCHAR(10)) + '; '
FROM SYS.SYSPROCESSES

SELECT @SQL

EXEC(@SQL)

Post #829687

« Prev Topic | Next Topic »

Permissions