SQLUSA

Microsoft SQL Server 2005

Best Practices

 

How to terminate orphaned connections?

 

Schedule the following script in SQL Server Agent at a low usage time e.g. 3 am:

USE master
go
EXEC sp_dboption 'AdventureWorks', 'offline', 'TRUE'
go
EXEC sp_dboption 'AdventureWorks', 'offline', 'FALSE'
go


 

The World Leader in SQL Server Training
 
SQLUSA.com Home Page