-
Work table row size... Help !!
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|