Identity Column

[FontanaS]

I keep getting duplicate numbers in a column that is set as an identity column.

The user interacts with interdev (web) and then there information is inserted in SQL. I do not even mention the identity column in the insert statement.

How is this possible?

THANKS

 

[Guest_imported]

Check the value of identity_insert value.
If it is set by the command
( set identity_insert table_name on )
table owner / database owner or sa can insert duplicate values in that column if they want.

Thanks