Post reply

See all tables that receive an UPDATE

  • April 28, 2009 at 7:40 am

    #155618

    I assume I should use SQL Profiler for this task.

    How do I run a trace that only creates a record when an UPDATE occurs. I only need to see the table name and either (1. The column(s) being updated, or 2. The UPDATE statement itself).

  • April 28, 2009 at 12:47 pm

    #985397

    Hi,

    in profiler you could create a new trace, select the event SQL:Batchcompleted only and setup a column filter for the column TextData (filter like %update%).

    So you'll get only the update statements.

    Maybe that helps 🙂

    -----------------------
    SQL Server Database Copy Tool at Codeplex

  • April 28, 2009 at 12:56 pm

    #985403

    Perfect, that's exactly what I needed.

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

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