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 |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2005-02-23 : 02:28:23
|
| Hi All,I have a table which has got many columns. I have set IDENTITY to one of the column that is ROWID with datatype numeric. Is it possible that there is duplicate records in this table including the rowid? If yes then why? And if no, please help me. As this happened with me :((.regardsSachin |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-02-23 : 05:05:11
|
if you have idnetity column then you can't have duplicates if you don't set identity_insert on.maybe someone put it to on inserted doubled data.set it to off.Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
IDENTITY!