InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 11:46:34 GMT20http://www.sqlservercentral.com/Forums/Topic1383797-23-1.aspxOne way could be to use an INSTEAD OF triggerThe below mentioned link could be of help to you[url]http://msdn.microsoft.com/en-us/library/ms175521%28v=sql.105%29.aspx[/url]Tue, 13 Nov 2012 23:33:00 GMTKingston Dhasianhttp://www.sqlservercentral.com/Forums/Topic1383797-23-1.aspxHi,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,AndyMon, 12 Nov 2012 11:32:20 GMTandy.richman