Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040

    Unanswered: SQL2k Profiler - Tracking inserts and deletes

    SQL 2K - SP3a - Development Box
    The environment is a piece of garbage ... triggers firing triggers firing triggers. Application is a piece of garbage that a developer want to make better (yea!) I need to put together a profile template to capture inserts and deletes into two tables.

    Not asking for the fish (but will accept it if necessary). Looking thru BOL, cannot find find an event class to capture insert and / or delete. Looking at TSQL event class gives SQLStmtCompleted event, and maybe I can filter on the two object IDs (object name not available because dbname not available as data column for this event.) Or if exists, but not documented, the event class for insert and delete.

    Any ideas?

    -- This is all just a Figment of my Imagination --

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    just have the trace go into a table, then query against that
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •