Error 1203

I am running a script on a schedule and I get this error quite often:

Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000] (Error 0) Process ID ## attempted to unlock a resource it does not own: OBJECT: ## . Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator. [SQLSTATE HY000] (Error 1203)

If I keep rerunning the transaction, it will eventually succeed. I am running SQL Server 2005 with SP1 installed. Does anyone know what this means and what would cause it to fail sometimes and succeed other times?

Thanks

This often indicates some sort of corruption in your database. See BOL topic below for more details:

http://msdn2.microsoft.com/en-us/library/aa337285.aspx

|||

It does not appear to be any sort of corruption. The DBCC CHECKDB returned no errors. Are there any other things that could cause this besided database corruption?

Thanks.

|||In that case, you will have to contact PSS to open a case so they can investigate further. This can also be due to a bug in SQL Server lock manager code caused by your workload/configuration. Btw, if you haven't applied the latest service pack of SQL Server (SP1) and the cumulative hotfix please do that first to see if you can repro the problem.