Error on a view

I am getting an error when I open a view err is:

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

How do I work aorund this issue?

On the assumption that you are using SQL Server 2000, there are a couple of KB articles on this:

http://support.microsoft.com/kb/818406
http://support.microsoft.com/kb/828269

Either way, it seems that the solution is to upgrade to SQL Server 2000 SP4.

Chris

|||

Chris,

That would be a long term fix. Is there any shortterm workaorund for this? pl let me know.

|||

Well, according to the second link I posted:

"If you still receive the "Msg 4414" error message, you may have to break up the query so that a lower number of tables or views are referenced in the query. You may change the view definition that is referenced in the problematic query to lower the number of tables that are referenced in the view."

Chris