Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE master;
- DECLARE @kill varchar(8000); SET @kill = '';
- SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), spid) + ';'
- FROM master..sysprocesses
- WHERE dbid = db_id('MyDB')
- EXEC(@kill);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement