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 |
|
Non-conformer
Starting Member
14 Posts |
 Posted - 2006-05-17 : 17:53:43
|
This should be a no-brainer.I'm trying to create a trace on a table. I wanna know whenever someone reads or writes to my table.On the "Events" tab, I selected "Object: Opened".Then on the "Filters" tab, I selected "Object name: Like" and entered the name of my table.I clicked "Run", then entered a query on my table in query analyzer.Nothing.What am I doing wrong?  Keep it simple.NC |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-05-17 : 23:27:11
|
You're not really doing anything wrong. Profiler sucks when you're trying to capture statements against one object. Make sure you limit events and the data columns to just what you need. Instead of using Object Name, use the Object ID. With SELECT OBJECT_ID('tablename'), you can find out what the ID is of the object. That's at least a little more accurate.  MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Profiler - what am i doing wrong?