![]() I think I should apply latest service pack and see if the issue exists. dbcc checktable ('sys.sysschobjs') Msg 5245, Level 16, State 1, Line 1 Object ID 34 (object 'sys.sysschobjs'): DBCC could not obtain a lock on this object because the lock request timeout period was exceeded. ![]() The information given is quite vague, and I am not at all acquainted with Tomcat-8. ETA - Follow up question - Is there any way I can lock the table to Management Studio manually so the drop. By default, there is no lock timeout in SQL Server, but it is possible that Object Explorer in SSMS sets one up, so it will remain unresponsive forever if there is blocking. (Microsoft SQL Server, Error: 1222) Any ideas I'm sure I'm missing something very obvious but I was under the impression non-clustered indexes are metadata only so should be quick and easy to drop. Following I would like to share with you some details about this issue and how to find and fix it. Net SqlClient Data Provider) using SQL Server Management Studio. This is what I got from sys.sysprocesses: Today, we got a service request that our customer got the following error message: Lock request time out period exceeded.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |