BurlCaballito45454
Technical User
Error : 610, Severity: 19, State: 1<br>Maximum number of databases that may be accessed by a transaction is 8. This number has been exceeded by this query.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Any way to solve this problem?.
- Thread starter BurlCaballito45454
- Start date
- Status
Not sure, but I think you deserve a prize for finding a new system constraint. More than 8 databases in a single query, way to go!<br><br>I am assuming that this is a single SQL statement. The answer may be to split the statement into two phases... i.e. put the results of half the query into a temporary table then use that table in the second query. <p> <br><a href=mailto: > </a><br><a href= home</a><br>
- Status
Similar threads
- Locked
- Question