How to tell sql server the maximum size my temp table will grow so that it does at most 1

How to tell sql server the maximum size my temp table will grow so that it
does at most 1 memory allocation?
DR (softwareengineer98037@.yahoo.com) writes:
> How to tell sql server the maximum size my temp table will grow so that it
> does at most 1 memory allocation?
You have posted this question independently to a whole bunch of newsgroups,
and it's not on topic to all. Only post to groups where the question is
relevant, and if you need to target multiple groups, cross-post, don't
multi-post. There is an answer for you in .programming.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
sql