sql profile on a given table

• Justin-14543

  SSCrazy

  Points: 2017

  More actions

  December 15, 2008 at 3:28 pm

  #155025

  I would like to trace this from a Sql Profiler. I do not want to create a trigger as this is just temporary. How can i do it. What are the filters? Basically if i have any insert, update, delete or select on this table, i want to know.

  Give me a fish, you feed me for a day! Teach me to fish, you feed me for a life time.

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  December 15, 2008 at 4:15 pm

  #912865

  set up column filters for the databasename (containing the object) and Textdata columns.

  assuming you were catching a table called "Blobdata" set the filter on textdata to

  Like %Blobdata%

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉