Greyeye/sqlkill-conn.sql

Created June 3, 2014 22:29

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Greyeye/9cfe29ff7a10f67d2b62.js"></script>
Save Greyeye/9cfe29ff7a10f67d2b62 to your computer and use it in GitHub Desktop.

Download ZIP

To kill all conn before starting mirror (or drop database) From http://stackoverflow.com/questions/7197574/script-to-kill-all-connections-to-a-database-more-than-restricted-user-rollback

Raw

sqlkill-conn.sql

	declare @kill varchar(8000) = '';
	select @kill=@kill+'kill '+convert(varchar(5),spid)+';'
	from master..sysprocesses
	where dbid=db_id('MyDB');
	print @kill;
	exec (@kill);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment