During Change Auditor troubleshooting, it is required to run SQL Profiler while Change Auditor is executing a certain operation. The following configuration of SQL profiler is recommended to have as much information as possible.
Use standard template and check "Save to file" checkbox and specify a location where trace will be created. It's a good idea to create a new folder because most of the time multiple files will be created during tracing and ALL of them need to be collected.
2. Switch to the Events Selection tab.
Under TSQL: SQL:StmtCompleted,SQL:StmtStarting
This is how events will look if you uncheck "Show all events"
4. In case you have multiple databases on the SQL server, you can limit profiling to specific databases by enabling Column filter:
After the configuration is done, start the profiling by clicking Run button and repeat the operation causing the problem.
5. After the operation is completed, Stop profiling. Archive the folder where trace files were generated and collect for analysis.
