I have a large select query which runs OK on our live server. However it always fails on the test server. The message is:

Work table row size 2082 which is greater than the maximum 2014. (or words to that effect.)

The Server configurations are identical, apart from the test server has less memory. The databases and tables are identical in structure and the database on the test server has been refreshed with 'live' data from the live system and all indexes have been rebuilt.

I can get the query to run, by removing columns from the select, but I dont understand why there are no problems in the live environment.

Any advice or help would be greatly appreciated.

Thanks in advance.

Tom W