How to get violated constraint name and the table name for which the constraint violated in SQL Server 2005

• dakshinamurthy-655138

  SSCertifiable

  Points: 5172

  More actions

  May 28, 2008 at 6:28 am

  #187182

  Hi,

  I have a task where in i need to send the constraint and the table name which got violated in a set of DML Statements in a Store Procedure,

  So please help me how to get violated constraint name and the table name for which the constraint violated in SQL Server 2005

  With Regards

  Dakshina Murthy

• adlan

  SSC-Addicted

  Points: 420

  More actions

  November 17, 2010 at 12:52 pm

  #1252115

  Maybe you could use Try/CATCH