• fizzleme - Tuesday, January 16, 2018 10:53 AM

    Can you recommend any reference material to help me get up to speed with this?    Are these specific trace events that can be referenced when table rows are deleted?

    Thanks.

    No. You're going to be looking for the same thing you would using extended events. You'll have to capture any rpc_completed or sql_batch_completed events. You can try filtering for the DELETE keyword and the tables you're interested in, but filtering in trace is pretty horrible. You'd be better off capturing the events and then filtering the results after the fact. For example, set it up so that the trace outputs to a file. Have that file roll over every fifteen minutes. You then schedule something that reads the old file every fifteen minutes, looks for this particular sets of strings, then delete that file. It's not as good as extended events, but it will work.

    "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