T-SQL to Know and compare Deprecated features with in SQL Server

Here's an easy approach to know the deprecated features with in your SQL Server.


SELECT * FROM sys.dm_os_performance_counters WHERE OBJECT_NAME LIKE '%Deprecated Features%'

You can also compare this DMV with SYS.all_sql_modules to identify the deprecated features in the stored procedures.




...Happy SQLing / Thanks for Visiting and Sharing your Views