> Could someone give me an idea of how to address the following problem:
> SQL 6.5
> Customer was testing their backup procedure by backing up their "real"
> database and restoring
> it to another database.
> Note: Train is the destination database and Taxcalc table is a table
> another application (Solomon I think).
> The message reads:
> An error occurred on a query to table Train..TaxCalc.
> SQL Server returned the following error message.
> Maximum number of used databases for each query has been exceeded.
> maximum allowed is 8.
> Thanks for your input.
The message is self-explanatory. There is limit of 8 databases
referenced in a query in SQL Server 6.5. Any reference counts as a
database, even if refers to the same database.
This means that a query that works without database qualifiers and just
uses the current database can use up to 15 tables in a join. If you add
database qualifiers to the query and run it from another database, the
maximum number of tables (now in a different database) is 8. I guess
that customer ran a query referencing another (the restored?) database
that did not account for this limitation.
Well, I'm sure we can resolve this in a mature
way. Right, Mr. Poopypants?
-- Leslie Nielsen
--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---