Server-side traces and extended events are how I do that kind of thing. You can capture any DML events you want to, and filter them pretty much however you like, using either of those.
I recommend extended events, because Microsoft says they'll sunset traces in a future version of SQL Server and to use extended events for new development.
Data on the subject here: http://msdn.microsoft.com/en-us/library/dd822788(v=SQL.100).aspx
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon