• Thanks Eugine, as I said I thought they were persisted even after the process that created them was closed,

    I was actually confused with creating a specific fixed table,Eg Create Table Tempdb..Test (Col1 int) within the temp db.

    so added that to my knowledge base, along with following the Natural Key vs IDENTITY thread. 😉

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices