>If I write a sp very complex one,
>where i declare 300 table variables !!!
Hey Fabio, Can you post the Stored proc, maybe we can help get rid of some of the vars that you need by re-writing some of the queries, a second set of eyes is always nice, well in this case on UT multiply the number of users and the number of people that check the SQL server forum and maybe just maybe some one may be able to help reduce the number of DECLARE @Tables that you need.
Just my 2 canuck cents worth.
--> Shawn