resetting an ident with a stored procedure that automatically increments it

• craig 84462

  Say Hey Kid

  Points: 669

  More actions

  April 6, 2010 at 10:22 pm

  #231472

  hi there,

  I am updating some dimensions and OLAP cubes in SSIS with a package for each. What is the package does for each is that it executes a stored procedure and used @@IDENT to output the identity into a new table. I wrongly executed a ssis package and now I need to reset the indent back to a specified value. ANy way this can be done?

  thanks

• Paul White

  SSC Guru

  Points: 150468

  More actions

  April 6, 2010 at 10:37 pm

  #1147004

  Link: DBCC CHECKIDENT

  Paul White
  All articles available on SQL.kiwi
  @SQL_Kiwi