April 28, 2009 at 4:59 am
Hi,
Is there any way to determine insert's, update's and delete's number on a table without having to use triggers on every table?
A system table like dm_db_index_usage_stats...
Thanks,
Pedro
April 28, 2009 at 6:14 am
You might look at Change Data Capture. Here's an article on auditing on MSDN. That might help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 28, 2009 at 6:16 am
Oh, and Tom Larock has a new article [/url]over at Simple Talk on using Audit.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 28, 2009 at 7:01 am
Thanks for the tip but we use Web Edition and doesn't support Audits....
I'll have to use the triggers :ermm:
April 28, 2009 at 7:39 am
What about Change Tracking? (not the same as Change Data Capture) It's available on all editions.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 28, 2009 at 7:47 am
Isn't change tracking a little "heavy"? It stores the data changed into a table...
My purpose is to know just the number of inserts,updates and deletes in all tables...
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply