Hi, trying to audit SQL in/out of SQL server from one of our apps which uses NHibernate. Tool I use is SQL Profiler. I noticed a lot of "SELECT" statements using "SQL:StmtCompleted" or "SQL:BatchCompleted" - however, I can't locate the expected UPDATE/DELETE. I do, however, notice a lot of "Unprepare statement" - but it doesn't show the SQL statement being executed against the SQL Server. It surely occurred, but which event/data column should I monitor?

Thanks in advance.

I generally just use the default filters and and adjust them to filter on the host and database name. Everthing appears fine for me. It sounds like you must have some weird filter in the mix that is stopping the other statements from appearing.