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
--sb--