With every release of SQL Server, new features are added. Also, some features are discontinued or marked as deprecated, which means that they’ll be removed in a future version of SQL Server. Starting with SQL Server 2008, the deprecation policy is taken very seriously. How seriously? Seriously enough to mention that the first public CTP of the product came with a feature that allows you to monitor usage of deprecated functionality. You may ask yourself: why would I need to track the usage of deprecated features?
Among the possible reasons are the following two: