Well Yes it is in the TempDB but you cannot see it from the Enteprise Manager.
I just uploaded a tool that help verify if the table in in the TempDB.
You can download this tool in this forum Files Download section Store Procedure.
>I don't know for sure, but I think it ends up in the TempDB database!
>
>
>>When I use the ## in the SELECT INTO commmand MS SQL will create a temporary table.
>>
>>Where can I find the table in the Enteprise Manager?