INDEX returns cryptic message

• cdb363

  SSC Rookie

  Points: 42

  More actions

  April 8, 2008 at 9:59 am

  #188788

  I have created Indexes on various tables, some prevent duplicates by using Unique record options

  The index returns non user friendly messages if violated such as “Cannot insert duplicate key row in object 'dbo.mytable' with unique index 'UIX_unique_Index'.

  The statement has been terminated.”

  Is it possible to have my own message returned or no message at all?

  Thanks

  CB

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  April 8, 2008 at 10:23 am

  #799885

  You can trap the error with a TRY/CATCH block, and return the error that you want.