Posted by Michael.Suarez on 03/22/06 15:59

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

• Next in forum: Re: Update n rows
• Prev in forum: Update n rows
• Thread view: Maximum number of databases used for each query in 2005?

[Reply to this message]