January 20, 2010 at 12:33 am
Message
Executed as user: dbo. Violation of PRIMARY KEY constraint 'PK_ErrorTrans'. Cannot insert duplicate key in object 'dbo.ErrorTrans'. [SQLSTATE 23000] (Error 2627) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed.We are using SQL 2008
Regards,
Goods
January 20, 2010 at 1:45 am
Seriously, what do you expect from this forum ?
Without more detail on when this error occurs all that i can say is that you are inserting (possibly updating) data into ErrorTrans that has caused a violation of the primary key. But you already knew that.
January 20, 2010 at 4:58 am
That's a primary key violation. So you tried to insert two rows with the same value in the primary key column (or columns).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 20, 2010 at 5:25 am
Thanks you...point taken.
January 20, 2010 at 5:26 am
THANKS GRANT
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply