Tuesday, December 22, 2015

Identity jump issue in sql server


  1. Open "SQL Server Configuration Manager"
  2. Click "SQL Server Services" on the left pane 
  3. Right-click on your SQL Server instance name on the right pane ->Default: SQL Server(MSSQLSERVER)
  4. Click "Properties"
  5. Click "Startup Parameters"
  6. On the "specify a startup parameter" textbox type "-T272" 
  7. Click "Add" 
  8. Confirm the changes

No comments:

Post a Comment