• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • 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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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