Inserts/deletes/updates are not visible in SQL Profiler.

entity-framework sql sqlprofiler sql-server-2005

Question

When I run the profiler while running my application, it only seems to show SELECTs, not INSERTs or anything that changes the database. Yet my database is being updated, so those commands must be being executed. What do I have to do to get it to show updates? (I am using Entity Framework, btw, if that might make a difference.)

1
9
9/21/2010 11:58:49 PM

Popular Answer

I figured out how to do it - I had to select SQL:StmtStarting and SP:StmtStarting, not just SQL:BatchStarting or SP:Starting.

Not sure what the differences are, but the inserts/deletes, etc. It showed up when I included those events.

11
4/10/2013 8:23:30 PM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow