FN-FORUM: SQL Server Problem

date posted 18th January 2006 09:18

Hi,
I've a SQL server problem - I'm getting an error saying that we've
exceeded the maximum number of databases are in a query (8). But I don't
get any indication in the logs as to what the SQL that's generating this
is. Any ideas how to find out what the SQL (I'm guessing it's a stored
procedure) is that's running to cause this ?

I've googled for the error but it just goes on about recursive queries
or bugs in query optimizers which is fine *IF YOU KNOW THE QUERY*

Cheers
Andy