As I love this feature (Deprecation feature warns you through perf counters or SQL Trace events that you are using features that will be removed in future versions of SQL Server), I played a lot with it and I found some surprises:

  • They were not included in the sqlserver package of XEVENT
  • They cannot be traced using SqlTrace Collector (or at least not yet)

For the first one I filled a connect request http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=327088 and what do you know: Jerome Halmans (the Program Manager of SQLOS) give me the good news that CTP7 will include deprecation events in sqlserver package of XEVENT.

What is not clear yet and I am waiting for an answer from Microsoft is "Can you use the SQL Trace Collector on a custom trace or just on the Default Trace?". I am still waiting for this one.