SQL Trace or SQL Trigger
Posted on 2010-01-06
Hi to all,
I am trying to trace insert, delete or updates on 4 tables in my SQL database. I am not very good with SQL pro-filer and I don't know how to create a trace on only 4 tables. The trace I currently have shows ALL SQL queries on the whole database and the is to much. I read that a trigger might be a better way to go, but I also do not know how to create a trigger to accomplish that.
The tables I want to trace is: PurchaseOrder and PurchaseOrderDetails. Workorder and WorkorderDetails.
What is the best way to go and is there a sample or walk through that I can use or work with.
Thanks to all