• Are you seeing 0's in your table currently, or are you referring to @@identity returning a 0 during this proc?

    According to script and table definition, you should not be inserting any 0's nor should you be able to have any more than one 0 in your table.

    Try adding a semi-colon after the insert statement, and try using ident_current rather than @@identity.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events