Well I ended up running a dbcc dbrepair with the allow data loss option.  It fixed the problems but we're worried about what data might have been lost.  Another thing...

Interesting discussion.  I've got a customer who wants a trigger setup for using xp_sendmail and I'm glad to have this info ahead of time.

Here is a possibly relevent kb article I found...

Thanks Noel!  I'll try a query off of that and see what I get.

So nobody knows a way to take the info provided in the error message to look at...

That article is exactly the problem however I looked at the table and found nothing with the IGNORE_DUP_KEY clause turned on in any of the properties.  (I had to check manually...