Sage Evolution
Space shortcuts
Page tree
Skip to end of metadata
Go to start of metadata
Kill all connections to database
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('<<DB NAME HERE>>')

EXEC(@kill);
  • No labels

1 Comment

  1. Alexander Toufexis

    Note, this doesn't work on al SQL servers! 2008R2 → doesn't seem to work? (database_id not existing field)