Hi,
How to Change Increment Value for existing Identity Column (MS SQL2000) ?
I know how to change the seed :
DBCC CHECKIDENT (activity, RESEED,4233596)
but I need the future id generated with step 2
4233596
4233598
4233600
I would like to do it using T-sql because I will need to do it every day after syncronising with another SQL server .
Thanks,
NataliaYou have to drop and recreate the table.sql
Showing posts with label dbcc. Show all posts
Showing posts with label dbcc. Show all posts
Subscribe to:
Posts (Atom)