Kill All User Sessions

• ashokjanjani

  SSC Journeyman

  Points: 83

  More actions

  September 23, 2007 at 2:33 am

  #177598

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

• JOn-323586

  Grasshopper

  Points: 20

  More actions

  December 16, 2007 at 9:40 pm

  #760610

  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

• 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)