Where does SQL server Identity column information stored?

• Question

• 

  

  0

  Sign in to vote

  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