Showing posts with label Process. Show all posts
Showing posts with label Process. Show all posts

Saturday, 4 February 2012

To KILL All the process in the current databases


ALTER DATABASE mydb SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE mydb SET MULTI_USER
GO