November 3, 2004 at 7:57 am
I'm getting this error when running a request through a browser, if i shorten the request the query runs ok.
The machine is SQL2000 sp3 on W2k sp3.
On an identical spec/installed machine the query runs ok....... Has anyone got any suggestions, both machines are SQLXML 3.
Any help much appreciated.
Jas
November 4, 2004 at 6:54 am
Maybe the length of one rows of the results goes over 8060 bytes (which is the maximum allowed by sqlserver). The data might be different from server to the next which would explain why it works on one server but not the other.
Can you post the queries and some sample data so we can have a further look?
November 4, 2004 at 8:38 am
The length was only about 3000 bytes. I've given up and put it into a stored procedure which seems ok, thanks anyway.
For info, the initial query causing problems was:
This worked fine on one machine but not on another.... bizarre.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply