i thought that may be the answer, i was hoping that i could use some function for it... THANKS !

😀 Thanks... should have known that !!

😀 Thanks... should have known that !!

BOL says:

A table variable behaves like a local variable. It has a well-defined scope, which is the function, stored procedure, or batch in which it is declared.

Within its scope,...

thanks.. i was wondering about that.. i do have some report_table's that get updated on a regualar basis and i think that it may fit there. as fars as users...

simplest answer:

Select * into #TempTable from Table

everyone ! thanks alot... i was doing the backups and db shrink, and it was working for a while, but since i have this data in a few diffrent places...