The following SELECT statement shows the number of inserts occurring on a particular object:
SELECT InsertCount FROM DBC.InsertUseCountV WHERE DatabaseName = 'Personnel' AND ObjectName = 'Employee';
Result:
InsertCount ------------ 9
The following SELECT statement shows the number of inserts occurring on a particular object:
SELECT InsertCount FROM DBC.InsertUseCountV WHERE DatabaseName = 'Personnel' AND ObjectName = 'Employee';
Result:
InsertCount ------------ 9