Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by rooksmith
-
switching to single user mode for scheduled jobs?
The reason it works sometimes and not others is that if there actually is something to repair, the database must be in single user mode. Furthermore, you cannot just switch to single user mode - you need to kill all the processes on that database first. Since this is not polite, the other...- rooksmith
- Post #5
- Forum: Microsoft SQL Server: Programming
