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
Post a Comment