>According to BOL, "Length of a string containing SQL statements (batch size) 65,536 * Network packet size". The default Network packet size=4K so limit would be 256MB.
>Are you using UNION or UNION ALL? Ifv the first, try to change it to the second.

Ok, thanks, I'll give that a try.

Kev