• Jeff Moden (5/1/2008)


    Michael Valentine Jones (5/1/2008)


    It's probably better to avoid using a reserved word, like INDEX, for a table name.

    Or "number" or "sequence" or... that's all part of the reason why I use "Tally". 😉

    NUMBER is not a reserved word. Maybe you are thinking of NUMERIC?

    SEQUENCE is not a reserved word in 2005, but is listed as a future reserved word in 2005 BOL.