ricardomijares64 (11/23/2012)
Sorry, I try again, my vocabulary in English is not very good...Hello all. I would like to help me please. I need to monitor the inserts and transactions that are made to the tables in a database . I want to make a constant monitoring of the inserts to be taking into my database and consultations, UPDATE, DELETE ... I would not use trigger because I consuming resources.
I have Sql Server 2008 R2 Standard Edition.
If you want to monitor, I would suggest a profiler trace. Be very careful though - you want to filter down the trace template down to only exactly what you want to see, as this can also be very resource intensive if not configured correctly. You can also pipe profiler output to a file and/or a SQL table. I assume that all of your insert / update / delete code is unencrypted, of course.