Nivi sharma

Nivi sharma

  • 1.8k
  • 195
  • 3.8k

Identity column value gives 1001 instead of 1 in sql

Aug 14 2020 7:05 AM


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.

Brought to you by:

Answers (4)