Post reply

What is the Process of tracing only Insert and Update command using SQL Profiler

  • August 21, 2008 at 5:07 am

    #196609

    Can anyone please tell What is the Process of tracing only Insert and Update command using SQL Profiler. I am using SQL Server 2000 and tracing data for some sequrity issues.

  • August 21, 2008 at 6:14 am

    #861156

    You could add a LIKE filter on the TextData column for %insert% and %update%.

    _____________________________________________________________________
    - Nate

    @nate_hughes

  • August 21, 2008 at 6:20 am

    #861162

    Make sure you trace the StoredProcedure:StmtCompleted event and not the StoredProcedure:SPCompleted event.

    If you trace the procedure completed, you won't see any inserts/updates within those procedures.

    Also trace the T-SQL:Stmt completed to catch andy batch requests.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 22, 2008 at 11:52 pm

    #862201

    Thanks a lot Sir.........Now it is Working fine.......

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

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