SQL Server 2008 Deprecated Features
This is a quick tip to show you how to list the SQL Server 2008 deprecated features and how to tell if they are still being used in any of your databases.A deprecated feature is one that will not be supported in a future version of SQL Server.
These old features can still be used, but you need to start modifying code now to ease the transition when you upgrade.
The list of deprecated features can be viewed in Books Online, where they are divided into those due to be removed in the next version, and those that will removed after that.
Microsoft have added a Performance Counter object to enable use of these features to be tracked, but using perfmon is not the most convenient way of doing it. Luckily, you can query a DMV:
This will return all SQL Server 2008 deprecated features that have been used since the last service restart, together the number of occurrences.
Not found what you're looking for?
Use this search box. It is tuned for SQL Server searches. Try it and see!