Hi Sergey,

Thanks. I checked out the thread. I'll try Mike's suggestions.

>See Re: Sp_tables skips # tables Thread #704369 Message #704624.
>
>>I am creating some #temp temp tables conditionally. I am doing a insert into #mytemptable, which creates the table. How can I check if the table exists. With a regular table I can do the statement:
>> if exists (select from dbo.sysobjects...)
>>
>>but this doesn't seem to work for a #temp table. HOw can I find out if a given temp table already exists?
>>
>>TIA