Getting the current Identity value RRS feed

  • Allgemeine Diskussion

  • Hi,

    When one reseeds a table with the following statement, is it possible to find out what was the last value that has been incremented


    If one try with other statment like IDENT_CURRENT('TABLE_NAME') there is a chance that the value that has been actually reseeded is different from the one which is given by the IDENT_CURRENT when parallel multiple transactions are running. Have any Idea how to actually find the value that has been updated?

    Montag, 30. Januar 2012 14:04

Alle Antworten