A Temp table only exists for the currnet session, correct? Is there any reason to put a DROP statement in there then?


>Hi Kevin,
>
>The prefix 'temdb..' is only needed for object_id(). The DROP TABLE does not need it.
>
>
>>
>>It's working. The table is being dropped, however the message
>>"Database name 'tempdb' ignored, referencing object in tempdb"
>>appears in the results pane each time I run it.
>>
>>
>>
>>
>>>You have to prefix a temp table with 'temdb..' as I shown in my original post. Try this one
>>>

>>>ALTER FUNCTION dbo.fnTableExists
>>>	(@sTableName VARCHAR(50))
>>>
>>>RETURNS TinyInt
>>>AS
>>>
>>>BEGIN
>>>	IF @sTableName LIKE '#%'
>>>		SET @sTableName = 'tempdb..' + @sTableName
>>>
>>>	RETURN CASE WHEN object_id(@sTableName) IS NOT NULL THEN 1 ELSE 0 END
>>>
>>>END
>>>

>>>