Results 1 to 2 of 2

Thread: Profiler

  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Post Profiler

    I need to run a profiler for any UPDATE that may ocur on a table of a database, ... and only to that table.
    What filter should I use? I tryed the Object ID LIKE , that I got from a SELECT * FROM SYSOBJECTS from my database, but it gets all transactions, and not only for that table.

  2. #2
    Join Date
    Mar 2003
    Location
    Woking, UK
    Posts
    152
    If I were you , I'd use TRIGGER rather than Profiler to trace any update.

    Anyway, You can trace Event "Secutity Audit.Audit Object Permission Event" and in Filter set ObjectName like "tablename".
    This will capture all select/insert/update/delete commands for your table
    Last edited by YuckFou; 04-20-2004 at 06:56 AM.
    You Have To Be Happy With What You Have To Be Happy With (KC)

Posting Permissions

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