• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 214
  • Last Modified:

How to setup a SQL 2000 trace


I'm fumbling around SQL Server trying to figure out how to setup a new trace. I'd like to save the trace to a file on my local drive (C:\Temp). I am only using the trace to monitor the database while I perform a single transaction from a third-party application. It will be done off hours, wtih no users connected to the Db.

Can someone show me how to set this up?


Mike S.
1 Solution
Hi Mike,

Just follow these steps:

1.  Open SQL Profiler from your Microsoft SQL Server program group in the Start Menu.
2.  Go to the File Menu -> New -> Trace...And login to your Server.
3.  Give the Trace a name.
4.  Click the Save to file checkbox.
5.  Set the file path (C:\Temp).
6.  Click Run.

That's it...

The trace will start and display any events occuring on the Server.  Use the toolbar in Profiler to Pause or Stop the Trace as you wish.


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now