while(exists(select column_name))-- i find it very effective way to loop through .. loops until the column contains value

 If @original_login_name='sa' and @database_id=@DB_ID

Begin 

--set @m =(select count(session_id) from sys.dm_exec_sessions where database_id=@DB_ID)

while (exists(select session_id from sys.dm_exec_sessions where database_id=@DB_ID))

Begin 

  set @killstatement = 'KILL ' + cast(@session_id as varchar(3))

            exec sp_executesql @killstatement

Comments