June 8, 2011 at 12:48 pm
I'm needing to capture write operations (any query that changes data) but only for two specific tables. Is this possible to configure in Sql Profiler? If so, how? I'm hoping for a solution that doesn't involve filtering on the text.
June 8, 2011 at 1:57 pm
I don't think you can do this with Profiler. You can do it using Extended Events though.
"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
June 8, 2011 at 1:59 pm
one thing you could try would be profiling a standard trace then taking the profile and dropping it into a table then delete the stuff you don't want or need. Granted it's a bit more labor intensive but I have used it in the past in a pinch.
June 8, 2011 at 2:53 pm
Depending on your requirements regarding tracking historical changes to the data either Change Data Capture or Change Tracking could be a good fit. Both are configurable at the table-level.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply