>Too much difficult to make a RELEASE @Table?
>Of course i can use a CREATE TABLE #blabla, but the point is not this.<

No, I know and I agree. However, if there's no way to do it, you have no choice (if there *is* a way, maybe Sergey knows it ... but I don't). I guess you could use the #TempTables only for the ones you know you have to DROP (I know, probably all of them, eh? <g>)

~~Bonnie




>>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