• The your first statement should start IF NOT EXISTS, should it not? In any case, please post the results of the following query:

    SELECT * FROM tempdb.INFORMATION_SCHEMA.COLUMNS

    WHERE TABLE_NAME LIKE '#temp%'

    John