Unanswered: How to monitor all sql query activities on sql server 7.0?
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.
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.