只要發生failover或是重新啟動sql server時,就會出現跳號1000的情況
微軟的說法是 There is a "feature" in SQL 2012 where the identity values are jumping by around 1000 each time the service is restarted.
https://connect.microsoft.com/SQLServer/feedback/details/739013/failover-or-restart-results-in-reseed-of-identity
解決方式:
在SQL SERVER 組態管理員裡面的startup頁面,加上-T272旗標,重啟後,測試OK