SQL Server Performance

Profiler Procedures

Discussion in 'General Developer Questions' started by royv, Aug 19, 2003.

  1. royv New Member

    I am interested in dumping data out of a database real-time. I know triggers are one way of doing this, but I was interested in another. I know of the stored procedures that SQL Profiler uses to monitor SQL Server. What I would like to know, is how do I monitor a single table and capture all events effecting this table via a C# program? How does SQL Profiler capture all the events real-time?

    "How do you expect to beat me when I am forever?"
  2. gaurav_bindlish New Member

    You can use the SQL Server trace procedures for that and set a filter for object id as the table object id.

    Seehttp://sql-server-performance.com/forum/topic.asp?TOPIC_ID=1401 for ample links on the same.

    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
  3. ykchakri New Member

    You can configure all the settings Using SQL Profiler as if you are going to run it manually and then script this using File/Script Trace option. This will create a script file that you can possibly embedd into your C# program.
  4. satya Moderator

Share This Page