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 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language Reference

Transact-SQL Reference

System Stored Procedures (Transact-SQL)

SQL Server Profiler Stored Procedures (Transact-SQL)

sp_trace_create (Transact-SQL)

sp_trace_generateevent (Transact-SQL)

sp_trace_setevent (Transact-SQL)

sp_trace_setfilter (Transact-SQL)

sp_trace_setstatus (Transact-SQL)

Minimize

This topic has not yet been rated - Rate this topic

SQL Server Profiler Stored Procedures (Transact-SQL)

SQL Server 2005

Microsoft SQL Server 2005 supports the following system stored procedures that are used by SQL Server Profiler to monitor performance and activity.

sp_trace_create	sp_trace_setfilter
sp_trace_generateevent	sp_trace_setstatus
sp_trace_setevent

Reference

System Stored Procedures (Transact-SQL)

Other Resources

Monitoring Events
SQL Server Event Class Reference
Using SQL Trace

Help and Information

Getting SQL Server 2005 Assistance

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.