how to reseed a table variable fileds identity value?

• anoop.sakthidharan-1120642

  Valued Member

  Points: 73

  More actions

  July 11, 2009 at 5:23 am

  #223438

  how to reseed a table variable fileds identity value

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  July 11, 2009 at 5:25 am

  #1023481

  Check BOL for "DBCC CHECKIDENT".

  Just out of curiosity. Why do you want to reseed your IDENTITY? There are some reasons, but they are really rare.

• SwePeso

  SSC-Dedicated

  Points: 39758

  More actions

  July 11, 2009 at 5:34 am

  #1023482

  And if you also want to reuse the identity values, see

  http://weblogs.sqlteam.com/peterl/archive/2009/03/10/How-to-efficiently-reuse-gaps-in-identity-column.aspx

  ---

  N 56°04'39.16"
  E 12°55'05.25"