Hello!
This is a newsgroup for the CLR (Common Language Runtime). It has nothing to
do with SQL-Server.
> How to tell sql server the maximum size my temp table will grow so that it
> does at most 1 memory allocation?
You cannot. But with the SQL-Server Storage Engine Architecture it is not
really nessersary.
You may use Bulk Commands / Utitlies to insert lange amount of data.
GP