No Luck, sorry

The tempdb still remains the same size.

Hi I've already tried the methods that do not requiere to restart my instance, but non of them worked, I want to know why I can't shrink it without restarting...

You are right Mr. GilaMonster,

I just checked again and all this temp tables have 0 rows, it seams that I read the wrong column, I queried the used_page_count column instead...

Now I get what you are saying, since I`ve tested your code. Well to answer your question I was messuring the size of this temp tables by running this query:

select...

Thank you very much to all of you,

I´ve finally know what these things are, Thank you parthi-1705 and GilaMonster, for clearing this up to me. I tested what you told...

Hi Wayne,

I really think they are not variable tables, because no user process is running on the server and the still remain, and as I said the are over...