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

No comments:

Post a Comment