With the impending arrival of Microsoft SQL Server 2008
come several new enhancements. These enhancements can be categorized as new capabilities, old constraints removed, and improvements in scalability. In the SQL Server community (including this blog) you can find numerous amounts of information on the new features found in SQL Server 2008
…however you seldom see much on deprecated features. Deprecated features are abilities of the new release which are either being removed completely or are being replaced by a future build of the software product. Discontinued features on the other hand are software features removed in the new release of the product.
Before I dive into the ‘list’ I wanted to mention that SQL Server 2008
includes a performance counter which will increment each time you use a deprecated feature. The counter is called SQL Server:Deprecated Features.
Plan accordingly prior to upgrading to SQL Server 2008
and of course leverage the SQL Server Upgrade Advisor which is bundled with the product as well as Scalability Expert’s SQL Server Upgrade Assistant which can be found at http://www.scalabilityexperts.com/default.asp?action=article&ID=43
Here is the deprecated & discontinued list by component, MSDN URLs:
SQL Server 2008 Reporting Services Discontinued Features