locked
Getting the current Identity value RRS feed

 > 

  • Allgemeine Diskussion

  • Discussion
    Anmelden
    0
    Anmelden

    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

    DBCC CHECKIDENT ('TABLE_NAME', reseed,10)

    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