SQL Server 2008 Discontinued and Deprecated Feature Link List

Just The Facts - SQL Server 2008: Deprecated & Discontinued Features!

“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. …

…

Here is the deprecated & discontinued list by component, MSDN URLs:

SQL Server 2008 Database Engine Deprecated Features

SQL Server 2008 Database Engine Discontinued Features

…”

Derek provides a nice link list of the discontinued and deprecated features in SQL Server 2008’s Database Engine, Reporting Services, Integration Services and Analysis Services. It’s pretty amazing the number of things in these lists.

The SQL Server team seems to have gotten real aggressive in their discontinue and deprecate drive. Hopefully setting the stage for more improvements, etc in future releases…

BTW, I dig the new Deprecates Features performance counter. I think that’s a cool way to help us look for things that may bite us in the butt in the future…