Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one.
See my reply in the other newsgroup.

Signature
Andrew J. Kelly SQL MVP
Solid Quality Mentors
> How to tell sql server the maximum size my temp table will grow so that it
> does at most 1 memory allocation?