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.)
Asked
Active
Viewed 7,999 times
13
-
Can you list which Profiler events you are tracking? Nothing's filtered, right? – Philip Kelley Sep 22 '10 at 00:00
1 Answers
16
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.
Rui Jarimba
- 11,166
- 11
- 56
- 86
Cynthia
- 2,100
- 5
- 34
- 48
-
3It looks like the key is also selecting the SPs. Even though we don't use stored procedures, our inserts/updates etc only show up if we turn on SP. Not sure why, but it works. – Slaggg Oct 01 '10 at 05:56