Derek Comingore Blog

Derek Comingore's Microsoft Business Intelligence Blog

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. 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 Database Engine Deprecated Features
SQL Server 2008 Database Engine Discontinued Features
SQL Server 2008 Integration Services Deprecated Features
SQL Server 2008 Integration Services Discontinued Features
SQL Server 2008 Analysis Services Deprecated Features
SQL Server 2008 Analysis Services Discontinued Features
SQL Server 2008 Reporting Services Deprecated Features
SQL Server 2008 Reporting Services Discontinued Features

Legacy Comments


JJEugene
2008-06-13
re: SQL Server 2008: Deprecated & Discontinued Features!
Thanks for this posting. I think it is helpful to review lists like these and start to think about what code needs to change.

Wayne West
2008-10-02
re: SQL Server 2008: Deprecated & Discontinued Features!
I heard today that Joe Celko is saying that the money datatype is being deprecated, I also saw the demonstration that it has a rounding error (http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/a544f732b84257dd/8926f7fa31fa4832?hl=en&lnk=st&q=#8926f7fa31fa4832).

Have you heard anything about it? Joe didn't post a cite after he was asked.