Microsoft KB Archive/225490

= BUG: Error 610 When a Query Generates More than 15 Worktables =

Article ID: 225490

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 6.5 Service Pack 5a

-



This article was previously published under Q225490



BUG #: 18229 (SQLBUG_65)



SYMPTOMS
When a single SELECT statement, which could include sub-queries, creates more than 15 worktables you may receive Error message 610:

Error 610

Maximum number of databases that may be accessed by a transaction is 8.

This number has been exceeded by this query.

The error occurs even though the SELECT statement only accesses one database. Those worktables may be generated explicitly or implicitly by reformatting, group by, sorting, and so forth.



CAUSE
This error message is misleading. The error has nothing to do with the eight database limit on a query statement. The error occurs because the implicit transaction hits the "max available transaction descriptors" limit, which is 16.



WORKAROUND
Avoid creating more than 15 worktables on a single query statement. If many worktables are generated due to reformatting, you may create indexes on the corresponding columns to avoid reformatting so as to reduce the number of worktables on a select statement.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.5.



MORE INFORMATION
This error does not occur in SQL Server 7.0.

Keywords: kbbug kbpending KB225490

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.