Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2014-08-21 : 10:14:03
|
| Hey, What are the right sql 2012 profiler events for tracing Select/Update to a specific table/view?I went into couple templates but did not find a way to limit by table/view names.I don't know if the calls coming as sp or t-sql, but do know the service account it comes as. This is to trouble shooting why the call did not make through.Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-21 : 12:31:31
|
| For the filters, use the loginname column for the service account and then the textdata column for the table/view using wildcards.(from memory, names might be slightly off):RPC:CompletedSP:StmtCompletedSQL:BatchCompletedTara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Profiler event selection help