SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Books Online for SQL Server 2012

Database Engine

Database Engine Features and Tasks

Database Engine Instances (SQL Server)

SQL Trace

Create and Run Traces Using Transact-SQL Stored Procedures

Create Manual Traces using Stored Procedures

Save Trace Results to a File

Improve Access to Trace Data

Create a Trace (Transact-SQL)

Set a Trace Filter (Transact-SQL)

Modify an Existing Trace (Transact-SQL)

View a Saved Trace (Transact-SQL)

View Filter Information (Transact-SQL)

Delete a Trace (Transact-SQL)

Optimize SQL Trace

Limit Trace File and Table Sizes

Schedule Traces

Minimize

This topic has not yet been rated - Rate this topic

Delete a Trace (Transact-SQL)

SQL Server 2012

SQL Server 2005

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

For an example of using trace stored procedures, see Create a Trace (Transact-SQL).

To delete a trace

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

Note
A trace must be stopped first before it can be closed.

Reference

sp_trace_setstatus (Transact-SQL)

System Stored Procedures (Transact-SQL)

SQL Server Profiler Stored Procedures (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.