• John Mitchell-245523 (1/9/2013)


    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

    Ooppss.....My Apologies.