This article is a step by step guide to perform post installation SQL Server steps
This article applies to all SQL Server versions
There is issue noticed in SQL database with table identities that are jumping values.
Due to this, in our sample scenario 6585 rows are taking 26879 primary key values:
This is an issue with SQL Server and similar issue is explained on link below:
Please login as SA or Db Admin, select MachPanel_DB (or whatever the DB name) for your installation
Scenario A: SQL Server version 2017 or Later:
Run below command to turn Identity Cache to Off.
ALTER DATABASE SCOPED CONFIGURATION SET IDENTITY_CACHE=OFF;
Scenario B: SQL Server versions Earlier than SQL Server 2017:
Perform following steps
- Open up the SQL Server Configuration Manager
- Click the left side of the SQL services in the below image.
- Right click on the SQL Server instant name at the right pane as
shown in the above image. Default value is: SQL Server (MSSQLSERVER),
Click the Properties option as shown in the above image.
- Click the Startup Parameters tab as shown the below image.
- Type -T272 in the Specify a startup parameter Textbox field and click Add
- –T272 parameter will appear in the Existing parameters section as shown in
- Click the Apply button and you will get the below Warning.
- Click OK, as Warring message pops up, and Restart the SQL Server instant service.