set-sql-server-alias-for-sql-server-agent-service-ssms.md

title	Set a Trace Filter (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	ssms
ms.topic	conceptual
helpviewer_keywords	filters [SQL Server], traces traces [SQL Server], filters
ms.assetid	7b976a84-7381-43a6-a828-ba83ada71cbe
author	stevestein
ms.author	sstein
manager	craigg

Set a Trace Filter (Transact-SQL)

This topic describes how to use stored procedures to create a filter that retrieves only the information you need on an event being traced.

To set a trace filter

1. If the trace is already running, execute sp_trace_setstatus by specifying @status = 0 to stop the trace.

2. Execute sp_trace_setfilter to configure the type of information to retrieve for the event being traced.

Important

Unlike regular stored procedures, parameters of all [!INCLUDEssSqlProfiler] stored procedures (sp_trace_xx) are strictly typed and do not support automatic data type conversion. If these parameters are not called with the correct input parameter data types, as specified in the argument description, the stored procedure will return an error.

See Also

Filter a Trace
sp_trace_setfilter (Transact-SQL)
sp_trace_setstatus (Transact-SQL)
System Stored Procedures (Transact-SQL)
SQL Server Profiler Stored Procedures (Transact-SQL)