Where does SQL server Identity column information stored? RRS feed

  • Question

  • Hi I couldnt find the exact forum where it should be posted.

    When working with multiple tables, which have identity columns, a single variable like @@identity cannot keep track of all tables identity info. Then where does sql server stores the identity info of each table?
    Krishna Sarma
    • Moved by Peter Ritchie Monday, June 2, 2008 6:03 PM more appropriate forum
    Monday, June 2, 2008 9:38 AM