ALTER SEQUENCE Schema.SequenceName
RESTART WITH 1
world wide web development problems asp net php html xhtml css javascript jquery w3dproblems
Tuesday, December 22, 2015
Identity jump issue in sql server
- 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
Subscribe to:
Comments (Atom)