Skip to Content
avatar image
Former Member

42000 Error

Getting the following error on a report that use to run:

Failed to open a rowset.

Details: 42000:[Microsoft][ODBC SQL Server Driver][SQL Server]

Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query ( 256 ) was exceeded.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 30, 2008 at 04:26 PM

    Hi Steve

    From the error message, it is clear that you received this error message because you have exceed the maximum number of tables that can be used in the SQL statement.

    The maximum number of tables that can be referred in a SELECT Transact-SQL statement is 256. This limit is documented under the "Maximum Capacity Specifications" section of the SQL Server Books Online.

    To overcome this issue, you can break the query so that a lower number of tables or views are referenced in the query.

    Hope this helps.

    Regards

    Poonam Thorat

    Add comment
    10|10000 characters needed characters exceeded