>Fabio,
>
>I'm not sure that you can release declared variables. Their scope is only to the SP, so they're gone when the SP is done anyway. That's not good enough?
>
>~~Bonnie

Absolutely not.
A stored procedures can be much complex and the created temporary tables can be many,
and the duration can be much long (also 1 hour);
if all this comes projected with the access of 1000 or more customers,
the memory allocation becomes much inefficient one.

Too much difficult to make a RELEASE @Table?

Another mystery ?

Fabio

Of course i can use a CREATE TABLE #blabla, but the point is not this.

>
>>I'm not able to found a command for release a Declared Table variable.
>>
>>I cannot think that a way does not exist.
>>If I write a sp very complex one,
>>where i declare 300 table variables !!!
>>
>>Thanks
>>Fabio