locked
Identity column value gives 1001 instead of 1 in sql RRS feed

  • Question

  • User186310208 posted

    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.

    Friday, August 14, 2020 12:04 PM

Answers

All replies