Are you experiencing an identity problem with your SQL Server 2012? Do the identity seeds of your records get increased by 1000 or 10000 ?
Seems like Microsoft has changed the way they deal with identity values in SQL Server 2012 and as a result of this you can see identity gaps between your records after rebooting your SQL server instance or your server machine. I will explain how I did it.
What I did: Setting Trace Flag 272 on SQL Server 2012:
Open “SQL Server Configuration Manager”
Click “SQL Server Services” on the left pane
Right-click on your SQL Server instance name on the right pane ->Default: SQL Server(MSSQLSERVER)
Click “Properties”
Click “Startup Parameters”
On the “specify a startup parameter” textbox type “-T272″
Click “Add”
Confirm the changes
Restart MSSQL.
Now you should be free of this annoying identity gap problem.
Thank you,
