Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [master];
- DECLARE @kill varchar(8000) = '';
- SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'
- FROM sys.dm_exec_sessions
- WHERE database_id = db_id('ifrs17_database')
- EXEC(@kill);
- drop database ifrs17_database;
- create database ifrs17_database;
Add Comment
Please, Sign In to add comment