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

>>