>
IF object_id('tempdb..#MyTable') IS NOT NULL
>
>
>
>>Hi,
>>
>>What is best way to determine if a temp table (#MyTable) exists prior to running a query against it. Sysobjects in tempdb has them - but lists all for all sessions/users. I need to know if it exists for the current session/user.
>>
>>Thanks,
thanks Sergey ....
Ken B. Matson
GCom2 Solutions