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.