Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
b211284
Starting Member
1 Post |
 Posted - 2010-12-15 : 15:23:14
|
| Can this be done by changing the seed value or identity increment (or some other way) in the MS SQL tables ?What about instead of setting the next value, can I update the increment and jump the value and then reset the increment to 1 to accomplish the same thing? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-15 : 15:27:10
|
| DBCC CHECKIDENT(tableName, RESEED, newValue) |
 |
|
|
|
|
|
Update Sequence to start from a higher value