Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Database Engine
Database Engine How-to Topics
Performance Monitoring and Tuning How-to Topics
Server Performance and Activity Monitoring How-to Topics
How to: Start Performance Monitor (Windows NT)
How to: Start System Monitor (Windows)
How to: Set Up a SQL Server Database Alert (Windows NT)
How to: Set Up a SQL Server Database Alert (Windows)
How to: View the Windows Application Log (Windows)
How to: View the SQL Server Error Log (SQL Server Management Studio)
How to: Create a Trace (Transact-SQL)
How to: Set a Trace Filter (Transact-SQL)
How to: Modify an Existing Trace (Transact-SQL)
How to: View a Saved Trace (Transact-SQL)
How to: View Filter Information (Transact-SQL)
How to: Delete a Trace (Transact-SQL)
How to: Create a Trace (SQL Server Profiler)
How to: Specify Events and Data Columns for a Trace File (SQL Server Profiler)
How to: Save Trace Results to a File (SQL Server Profiler)
How to: Save Trace Results to a Table (SQL Server Profiler)
How to: Filter Events in a Trace (SQL Server Profiler)
How to: View Filter Information (SQL Server Profiler)
How to: Modify a Filter (SQL Server Profiler)
How to: Set a Maximum File Size for a Trace File (SQL Server Profiler)
How to: Set a Maximum Table Size for a Trace Table (SQL Server Profiler)
How to: Start a Trace Automatically after Connecting to a Server (SQL Server Profiler)
How to: Filter Events Based on the Event Start Time (SQL Server Profiler)
How to: Filter Events Based on the Event End Time (SQL Server Profiler)
How to: Filter Server Process IDs (SPIDs) in a Trace (SQL Server Profiler)
How to: Pause a Trace (SQL Server Profiler)
How to: Stop a Trace (SQL Server Profiler)
How to: Run a Trace After It Has Been Paused or Stopped (SQL Server Profiler)
How to: Clear a Trace Window (SQL Server Profiler)
How to: Close a Trace Window (SQL Server Profiler)
How to: Set Trace Definition Defaults (SQL Server Profiler)
How to: Set Trace Display Defaults (SQL Server Profiler)
How to: Open a Trace File (SQL Server Profiler)
How to: Open a Trace Table (SQL Server Profiler)
How to: Replay a Trace Table (SQL Server Profiler)
How to: Replay a Trace File (SQL Server Profiler)
How to: Replay a Single Event at a Time (SQL Server Profiler)
How to: Replay to a Breakpoint (SQL Server Profiler)
How to: Replay to a Cursor (SQL Server Profiler)
How to: Replay a Transact-SQL Script (SQL Server Profiler)
How to: Create a Trace Template (SQL Server Profiler)
How to: Modify a Trace Template (SQL Server Profiler)
How to: Set Global Trace Options (SQL Server Profiler)
How to: Find a Value or Data Column While Tracing (SQL Server Profiler)
How to: Derive a Template from a Running Trace (SQL Server Profiler)
How to: Derive a Template from a Trace File or Trace Table (SQL Server Profiler)
How to: Create a Transact-SQL Script for Running a Trace (SQL Server Profiler)
How to: Export a Trace Template (SQL Server Profiler)
How to: Import a Trace Template (SQL Server Profiler)
How to: Save Deadlock Graphs (SQL Server Profiler)
How to: Open, View, and Print a Deadlock File (SQL Server Management Studio)
How to: Save Showplan XML Events Separately (SQL Server Profiler)
How to: Save Showplan XML Statistics Profile Events Separately (SQL Server Profiler)
How to: Extract a Script from a Trace (SQL Server Profiler)
How to: Correlate a Trace with Windows Performance Log Data (SQL Server Profiler)
How to: Open the Activity Monitor (SQL Server Management Studio)
How to: Organize Columns Displayed in a Trace (SQL Server Profiler)
Expand Minimize
This topic has not yet been rated - Rate this topic

How to: Delete a Trace (Transact-SQL)

SQL Server 2005

This topic describes how to use stored procedures to delete a trace.

  1. Execute sp_trace_setstatus by specifying @status = 0 to stop the trace.

  2. Execute sp_trace_setstatus by specifying @status = 2 to close the trace and delete its information from the server.

ms189898.note(en-US,SQL.90).gifNote:
A trace must be stopped first before it can be closed.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.