How to setup a SQL 2000 trace

Posted on 2005-05-11
Last Modified: 2010-03-19

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.
Question by:mschonlau
    1 Comment
    LVL 6

    Accepted 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.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now