July 26, 2006 at 4:46 pm
One of my users is updating a table that they should not be. I cannot do anything about their ability to update at the moment, but I would like to track down the offending party.
The problem is that I am having a hard time filtering out the results in query profiler that I need. Basically I am trying to get results that only include the sql:stmtstarting text data for 'update hsi.plattertable'. The dataset I get includes this information plus all of the stmts with blank text data. The filters I am using are as follows
databasename=testdb
text data='update hsi.plattertable%'
Any suggestions on how to get rid of these blank results would be great
Thanks
July 27, 2006 at 6:10 am
If the TextData column data is blank, then SQL2000 profiler will always display them I'm afraid. There's no way of avoiding this (at least, none that I've ever found, and believe me I've tried!)
SQL2005 Profiler allows you to specify an option "Exclude rows that do not contain values" as part of the column filter(s), which greatly simplifies the output.
Sadly, this option is disabled if you use a 2005 Profiler client against a 2000 database.
The best suggestion I can make is that you save all your results to a database table, and then delete all records where TextData is NULL.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply