Home Forums Article Discussions Article Discussions by Author Discuss content posted by ashokjanjani Kill All User Sessions RE: Kill All User Sessions

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