Thursday, May 24, 2012

Query To get list of deprecated features in SQL Server 2008

We can get the list of deprecated features in SQL Server 2008 with a simple query.

SELECT * FROM sys.dm_os_performance_counters WHERE OBJECT_NAME like '%deprecated%' order by cntr_value desc