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 |
|
danasegarane76
Posting Yak Master
242 Posts |
 Posted - 2009-05-19 : 03:14:31
|
| Hi All, Will the DBCC CHECKIDENT (Transact-SQL) command insert produce a duplicate in the identity column ?ThanksDana |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-05-19 : 04:44:00
|
| No, it will fail if it tries, (I am guessing your identity field is you clustered index, if it is not, then it is possible to insert duplicates).You can use it two ways, if you use the noreseed option, then it will just give you the next number to be inserted. or you can reseed with it. |
 |
|
|
|
|
|
Identity Field