Does anyone have a solution to this problem?
SQL Server Assertion: File: , line=10850 Failed Assertion = 'GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.
Actions that are already taken:
- DBCC Checkdb no_infomsgs - reported no problems.
- DBCC CHECKDB, report 0 errors, 0 consistency errors.
Environment:
- Windows Server 2003 R2 Enterprise Edition 64Bit SP2
- Microsoft SQL Server Standard Edition (64-bit) Version 9.00.3042.00
1 Answer 1
This sounds like a known issue with SQL Server 2005. This page from MS details both a patch if you can upgrade, and a workaround if you cannot.
-
@Amir - Let us know how you make out with this!JNK– JNK2010年11月04日 13:53:39 +00:00Commented Nov 4, 2010 at 13:53