Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004

    Thumbs up Unanswered: How to monitor all sql query activities on sql server 7.0?

    Hi Gurus,
    I have a database server running on a sql server 7.0. Some external app is accessing this db server, reading and updating some tables. For some reason, some updating actions didn't work. I just want to track those updating actions, and see if there're some logs reporting failure reason. Is there some tool in sql server 7.0 that could help me do that? Thank you.

  2. #2
    Join Date
    Jul 2004

    Thumbs up Use Profiler


    You can use profiler to monitor all activites which take place in the server. You can also set filters so that u can monitor the activites from a particular client or application. From the trace u can see all those update queries.

    Hope this helps you...

    My Blog

  3. #3
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    SQL Server 7.0 included SQL Profiler. Although very primative compared to the SQL-2000 Profiler, it allows you to track most client activity. It should be able to do what you've described.


Posting Permissions

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