Change Tracking

• NicHopper

  SSCrazy Eights

  Points: 9090

  More actions

  December 30, 2014 at 3:37 am

  #314173

  Hi,

  I just wondered if anyone knew how to reset the value of the change tracking anchor id?

  CHANGE_TRACKING_CURRENT_VERSION()

  It's a bigint that increments on every DML operation and I just wondered how you could reset it back to zero. Turning change tracking off and on doesn't seem to do it.

  Thanks,

  Nic

  Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

• Uwe Ricken

  Hall of Fame

  Points: 3169

  More actions

  December 30, 2014 at 4:45 am

  #1766965

  Hi Nic,

  there is no way to reset the CT number!

  https://social.msdn.microsoft.com/forums/sqlserver/en-US/2d0657f5-bdea-4385-9f80-1cb16d8554bc/resetting-change-tracking-version

  If you need to reset the numbers I would suggest to disable CT and recreate it...

  Microsoft Certified Master: SQL Server 2008
  MVP - Data Platform (2013 - ...)
  my blog: http://www.sqlmaster.de (german only!)

• NicHopper

  SSCrazy Eights

  Points: 9090

  More actions

  December 30, 2014 at 4:55 am

  #1766967

  Thanks Uwe.

  Regards,

  Nic

  Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/