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 |
|
swatib
Posting Yak Master
173 Posts |
 Posted - 2005-12-13 : 06:48:11
|
Hi All,How do I reset or reseed the IDENTITY column? Njoy Life  |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-13 : 07:01:29
|
| DBCC CHECKIDENT (TableName, RESEED, 0)MadhivananFailing to plan is Planning to fail |
 |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2005-12-13 : 07:02:29
|
| DBCC CHECKIDENT ( 'table_name' [ , { NORESEED | { RESEED [ , new_reseed_value ] } } ] ) |
|
|
|
swatib
Posting Yak Master
173 Posts |
Posted - 2005-12-13 : 07:03:47
|
| Many Thanks!!Njoy Life |
|
|
|
|
|
|
IDENTITY column