Post reply

Profiler tracing question

  • June 9, 2009 at 2:18 pm

    #132862

    I am trying to setup Profiler to trace a specific userid on a specific db that is doing a delete against one table. I have the dbid in, user id but I am having trouble narrowing it down more than that. In ObjectName I put the owner.table name in the LIKE but that filter does not work as it simply gives me ALL SQL statements running on in the db and that is too much info. Any ideas on how to drill down further? This is SQL 2000 SP4.

  • June 17, 2009 at 3:04 am

    #1010710

    If I were in your position I would run the trace as you have it now. Then load the data into a table and use sql-queries to delete all the info you don't want.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply