Date Time SPID Error: 1203, Severity: 20, State: 1.
Date Time SPID Process ID SPID attempted to unlock a resource it does not own: DATABASE: n . Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator.
Date Time SPID Process SPID unlocking unowned resource: DATABASE: n
Important information for SQL Server 2005 Analysis Services
A known issue exists in Cumulative Update 7 for SQL Server 2005 Analysis Services. Consider the following scenario. You install Cumulative Update 7 for SQL Server 2005 SP2. In SQL Server Profiler, you start a trace or stop a trace. Then, you run a query. The execution time of the query exceeds the value of the ForceCommitTimeout server setting. In this scenario, all the queries that are running on the server are canceled. To work around this issue, do not run MDX queries before you start a trace or stop a trace.
Article ID: 951188 - Last Review: Nov 19, 2008 - Revision: 1