Microsoft SQL Server forum - Maximum number of databases used for each query in 2005?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Maximum number of databases used for each query in 2005?

Michael.Suarez@gmail.com

2006-03-22, 9:28 am

In MS Sql Server 2000, if you run a stored procedure that query's more
than 8 databases, you get this error gets raised:

Maximum number of databases used for each query has been exceeded. The
maximum allowed is 8.

In 2005, does this maximum number still exist? if so, is it still 8, or
has the number been increased?

Thanks,
Mike

figital

2006-03-22, 9:28 am

Holy Moly, what kind of queries are you writing!?

Sponsored Links