Identity column value gives 1001 instead of 1 in sql

Aug 14 2020 7:05 AM

Hello..

Can anybody have any idea why it gives value 1001.... i also tryed

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.

Answers (4)