Bug #: 422521 (SQLBUDT)
Lock request time out period exceeded.
ALTER DATABASE <Database Name> SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE <Database Name> SET MULTI_USER
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: 951093 - Last Review: Oct 29, 2008 - Revision: 1