Count primary key violations on a table

• andy.richman

  Newbie

  Points: 1

  More actions

  November 12, 2012 at 11:32 am

  #98572

  Hi,

  I am relatively new to SQL Server. I have an app that frequently inserts values with the same key to a table. I need a way to monitor the frequency at which primary key violations are occurring on this table.

  It could be real time monitoring or gathering data after the fact. The key is I only want the counts for this 1 table.

  Thanks,

  Andy

• Kingston Dhasian

  SSCoach

  Points: 19799

  More actions

  November 13, 2012 at 11:33 pm

  #1558738

  One way could be to use an INSTEAD OF trigger

  The below mentioned link could be of help to you

  http://msdn.microsoft.com/en-us/library/ms175521%28v=sql.105%29.aspx

  ---

  Kingston Dhasian

  How to post data/code on a forum to get the best help - Jeff Moden
  http://www.sqlservercentral.com/articles/Best+Practices/61537/