- The client computer connects to the database server that is running SQL Server 2005 across a slow link.
- The query takes a long time to be completed.
- You cancel the query when it is being executed.
Additionally, if you query the sys.sysprocesses view when the query is being canceled, you see a result that resembles the following:
Cumulative update information
SQL Server 2005 Service Pack 2Important You must use this fix if you are running SQL Server 2005 Service Pack 2.
The fix for this issue was first released in Cumulative Update 11 for SQL Server 2005 Service Pack 2. For more information about this cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
SQL Server 2005 Service Pack 3Important You must use this fix if you are running SQL Server 2005 Service Pack 3.
The fix for this issue was also later released in Cumulative Update 1 for SQL Server 2005 Service Pack 3. For more information about this cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
- Connect to the server by using Remote Desktop Connection, and then run queries locally on the server.
- Set the maximum degree of parallelism (MAXDOP) hint to 1 in Transact-SQL queries.
- Set the MAXDOP option to 1 on the server.
Note We strongly recommend that you do not use this method. This operation may significantly affect the performance of the production systems because all queries will be affected.
Article ID: 960110 - Last Review: Dec 19, 2008 - Revision: 1