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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Unable to trace specific table

Author  Topic 

Peter Dutch
Posting Yak Master

127 Posts

Posted - 2003-10-03 : 02:41:19
I'm trying to run a trace (with profiler) on a specific table in my datbase (SQL2K). In the filters tab I enter the name of the table in the Object name like field but when I do a trace, the column objectname is empty and I get all events that occur in the db.

Anyone had this before?

nr
SQLTeam MVY

12543 Posts

Posted - 2003-10-03 : 12:36:20
Yep - I can't get anything for that either. I just use the db_id - anything else I do in the database itself.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -