SQLServerCentral / Discuss content posted by ashokjanjani / Article Discussions / Article Discussions by Author / Kill All User Sessions / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 14:30:25 GMT20RE: Kill All User Sessionshttp://www.sqlservercentral.com/Forums/Topic401541-458-1.aspxDECLARE @SQL VARCHAR(8000)SELECT @SQL = COALESCE(@SQL, '') + 'KILL ' + CAST(SPID AS VARCHAR(10)) + '; 'FROM SYS.SYSPROCESSESSELECT @SQLEXEC(@SQL)Mon, 07 Dec 2009 01:00:33 GMTrajdakshaRE: Kill All User Sessionshttp://www.sqlservercentral.com/Forums/Topic401541-458-1.aspxI 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 @uidset @out= 'kill ' + @outexecute sp_executesql @outSun, 16 Dec 2007 21:40:08 GMTJOn-323586Kill All User Sessionshttp://www.sqlservercentral.com/Forums/Topic401541-458-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Miscellaneous/30838/">Kill All User Sessions</A>[/B]Sun, 23 Sep 2007 02:33:59 GMTashokjanjani