#Table - Local temporary tables are visible only in the current session
##Table - Global temporary tables are visible to all sessions

Also check out the table_variables in BOL as this is generally a better way to handle temporary tables.

Regards,

Jon

>Thank's Jon.
>
>All this #Temp stuff is on the connection level, right?
>
>Two users with different (not shared) connections could both have a #Temp table containing different data at the same time?
>
>What happens if it's a shared connection?
>
>
>>IF Object_Id('tempdb..#tempas') IS Not Null
>>
>>>Well, that's pretty much it!
>>>
>>>Thank's in advance.
>>>
>>>BR