Maybe you shouildn't allow the error to happen in the first place?

>I am looking for suggestions on how to make better reporting of invalid entries back to the UI tier?
>
>For example, say user enters a duplicate value (where duplicate is not allowed). What I get from the SQL Server as an error message, is the following:
>
>

>Failed updating record in MyTable
>Cannot insert duplicate key row in object 'dbo.MyTable' with
>unique index 'IX_MyKey'
>

>
>I would like to make the message simpler for the end user to understand.
>
>Any suggestions would by greatly appreciated.