Primary Key Violation error code

hasanali00 · April 18th, 2005, 09:35 AM

Just for your info, 2601 is the number used as the primary key violation code in the ThPhile.

However, 2601 was not working for me. VS.net debugger displayed 2627 as the error code. I used 2627 to catch primary key violation code, and it did work.

englere · April 19th, 2005, 07:41 PM

Thanks for the info - it would be wise to handle both of these errors.

SQL Error 2627:
Violation of UNIQUE KEY constraint '%.*ls'. Cannot insert duplicate key in object '%.*ls'.

SQL Error 2601:
Cannot insert duplicate key row in object '%.*ls' with unique index '%.*ls'.