Sql Solutions
  • Home
  • Sql

Friday, 5 August 2016

Kill Thread in Database

 Unknown     23:20     No comments   

Please use this query with your database name 
this query will clear all threads ...

ALTER DATABASE <Database Name>
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
ALTER DATABASE  <Database Name>
SET MULTI_USER;
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
Email ThisBlogThis!Share to XShare to Facebook
Newer Post Older Post Home

0 comments:

Post a Comment

About Me

Unknown
View my complete profile

Popular Posts

Copyright © Sql Solutions | Powered by Blogger
Design by Ravi Budania