• AlanB, can you please elaborate why you suggest an identity column on this table? That is what almost all of my clients do on, well, every single table and many (including this one from what I know so far) just shouldn't have them.

    Based on other posts of yours I have read I don't think you are a ninny, so what am I missing here? 😉

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service