why are bounce primary key value in sql

Please follow below process to overcome this problem :

1) Go to the SQL Server Configuration Manager. Next, right-click on the Instance Name, and select the properties from the context menu.

2) Selecting the properties window will open the following window

3) Go to the Startup Parameters Tab and add -T272

4) Click Apply

5) Click OK and restart the SQL Server instance

Thanks

0

Priyanka Jain7y ago

You can check SQL Server logs which is inserted after any SQL services restarted or database is reattached

0

Kalyani Shevale7y ago

we are not using rollback n as well as we are not deleting any record. our project is live so our database in GoDaddy.we is not finding the route cause of this issue.???

0

Priyanka Jain7y ago

This may be due to some rollback or row deleted by SQL server or some services got restarted while insertion that may be result in breaking of sequence

+1