Extended Events | SQL_Text | Object_ID/Name | Filter Clause | SQL 2K8 R2 - by Mohanraj Jayaraman

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 790118 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 6/13/2013 9:07:14 AM
Access Restriction Public



In the extended events, Its not possible if I need to set a filter clause based on tableName / Object_Name but it exists in SQL2012. Please include this feature or guide us how to incorporate such feature in Extended Events. 

Mohanraj Jayaraman
Sign in to post a comment.
Posted by Microsoft on 11/12/2013 at 12:20 PM
Hello Mohanraj,

Thanks for your feedback. SQL Server 2012 was the first release were we announced deprecation of Profile Trace and migrated all the trace events to Extended Events. This is why you see more events and properties such as object name in SQL Server 2012 and later versions. Please continue to use Profiler trace for versions before SQL Server 2012 if you need to filter on events or columns that are not available in that version.

Ajay Jagannathan
Senior Program Manager