August 8, 2008 at 2:26 am
One of our Cognos reports crashed this morning out of the blue due to an SQL failure.
The source database is SQL server 2000 and the message indicated that the SQL executed exceeded 192 tables. Apart from the fact that this is due to bad design, is there a limit in SQL server 2005 for the number of tables (or views / alias) that are adressed in 1 query?
August 8, 2008 at 2:34 am
blom0344 (8/8/2008)
One of our Cognos reports crashed this morning out of the blue due to an SQL failure.The source database is SQL server 2000 and the message indicated that the SQL executed exceeded 192 tables. Apart from the fact that this is due to bad design, is there a limit in SQL server 2005 for the number of tables (or views / alias) that are adressed in 1 query?
There is an upper limit of 256 in SQL Server 2005, but the limit may be lower for complex queries.
see http://msdn.microsoft.com/en-us/library/ms177634.aspx
Regards,
Andras
August 8, 2008 at 2:37 am
Just a note that this limit seems to have stayed the same in SQL Server 2008, so upgrading to a newer version may not help here, and you should look at the query itself.
Regards,
Andras
August 8, 2008 at 7:24 am
Thanks, this makes things pretty clear!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply