Find Deprecated Features in SQL Server

Few days back I was working on project which involved server migration from SQL 2005 to SQL 2008. I wanted to find out what code that I use will not be available in the next version of SQL. These features are called as “deprecated features”. Now MS provides all kind of documents and links to read about it. But being a DBA I want to run a query and see the results J

Following will help you do it when it comes to deprecated features

SELECT * FROM sys.dm_os_performance_counters WHERE object_name LIKE ('%deprecated%')

object_name	counter_name	instance_name	cntr_value	cntr_type
SQLServer:Deprecated Features	Usage	ALTER LOGIN WITH SET CREDENTIAL	0	65792
SQLServer:Deprecated Features	Usage	SQL_AltDiction_CP1253_CS_AS	0	65792
SQLServer:Deprecated Features	Usage	Macedonian	2	65792
SQLServer:Deprecated Features	Usage	Lithuanian_Classic	2	65792

How to read the results

object_name	Category to which this counter belongs
counter_name	Name of counter
instance_name	Name of the specific instance of the counter. Often contains the database name.
cntr_value	Current value of the counter.
cntr_type	Type of counter as defined by the Windows performance architecture.