Search my blog
-
-
Recent Posts
- Reading list for the week – 24/10/11
- Reading list for the week – 17/10/11
- Reading list for the week – 10/10/11
- Reading list for the week – 03/10/11
- Reading list for the week – 26/09/11
- MSP Error: 29528 The setup has encountered an unexpected error while Setting reporting service exclusion path
- Reading list for the week – 19/09/11
Page Views
208,411-
Popular Posts
- How the Cannot generate SSPI context error was fixed
- Find the SQL Server Instance name using Task Manager
- Server is in script upgrade mode. Only administrator can connect at this time
- Script to check database user permissions
- Cannot create an instance of OLE DB provider ‘OraOLEDB.Oracle’ for linked server
Archives
Tags
backup configure data corruption data file hardware hotfix index internals locks maintenance plan performance PradeepAdiga restore RLFTW scripts security services setup sql 2000 sql 2005 sql 2008 sql 2012 sql agent ssis system databases tips and tricks tools Top Posts trace transaction log troubleshoot windows
Tag Archives: locks
Changes to the state or options of database cannot be made at this time
One of our production servers running SQL Server 2005 has LiteSpeed log shipping configured. It is configured to bring the database into Single user mode, apply the transaction log backups from Primary server and put the database back into Multi_User … Continue reading
Posted in Internals, SQLServerPedia Syndication, Troubleshoot
Tagged configure, internals, locks, scripts, sql 2005, troubleshoot
Leave a comment
Process ID owns resources that are blocking processes on Scheduler
A few days back one of the regular readers of my blog $sammy (not sure how he wants to be called, I will call Dollar Sammy ) saw continuous error messages on one of his SQL Server 2000 instances which … Continue reading
Posted in Internals, SQLServerPedia Syndication, Troubleshoot
Tagged internals, locks, performance, sql 2000, troubleshoot
1 Comment
RSS
Email
Twitter
Ovi App
LinkedIn
FourSquare