[SQL] Query to add Unique spot very fast

[MissinGDeaTh]

when i try to set identity for refobjcommon and refobjchar this error appears

'_RefObjChar' table
- Unable to create index 'PK__RefObjChar'.
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo._RefObjChar' and the index name 'PK__RefObjChar'. The duplicate key value is (18004).
Could not create constraint. See previous errors.
The statement has been terminated.

 

[CandyQ]

Msg 8106, Level 16, State 1, Line 25
Table 'Tab_RefTactics' does not have the identity property. Cannot perform SET operation.!!!

 

[sacphonghung]

I set mindealy = 60 max dealy = 120 . I donot see the unique app??