Sunday, February 17, 2008 11:30 AM
xmldeveloper
Deprecation Events - Small Victory
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.