| 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
Related article:
Troubleshooting Orphaned Users
|
|
