>>>Thanks again. UT is the best! Can you help me with this one?
>>>http://forums.asp.net/t/1715921.aspx/1?Problem+with+profiles
>>
>>This is not a simple problem. May be tonight I dig into my old files in regards to profile, as I remember we did have custom profile properties.
>
>Naomi -
>If I select into a temp table, how do I then access the temp table? Do I need to setup a new connection or does the original connection have access? What if the temp table is created via a stored procedure?
>Thanks

The # temp tables are visible in the connection that created it. #Temp tables created in the stored procedure are not visible in the outside batch - they live only in the scope of the SP.