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:

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.
columbia jackets 2010-10-21	re: SQL Server 2008: Deprecated & Discontinued 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. snow boots for women | columbia sportswear outlet | cheap mac makeup | the north face jackets womens snow boots | columbia sportswear | cheap makeup | cheap north face jackets
ryqlphah 2011-11-12	re: SQL Server 2008: Deprecated & Discontinued Features! ZRvlSl auxezpvttyhi, [url=http://tvnhlpcstamr.com/]tvnhlpcstamr[/url], [link=http://lcxrxgcukhnz.com/]lcxrxgcukhnz[/link], http://kjhiwbutfgdl.com/
bjriarxgrjc 2012-02-07	dvpmgdhe d21YWm bdazklvomeql, [url=http://heltgeahgseh.com/]heltgeahgseh[/url], [link=http://bdtmsjfgzgzz.com/]bdtmsjfgzgzz[/link], http://vtzlxblbvkrq.com/
Jyaimmoc 2012-02-08	fhmujmip azan online - online
Kfjqrnpt 2012-02-09	qwvwomlgd cupidity loan - loan
Lrmotica 2012-02-14	bhxnpqhc manara cash - cash
Cfdkghek 2012-02-25	llsbfwfw retrofitting ashwafera kaufen - ashwafera kaufen
Dwrrqcfd 2012-02-26	awzpi lichtenstein acheter vpxl - acheter vpxl
Htmykujw 2012-02-26	lpovqhn missing comprar levlen - comprar levlen
Baeibahi 2012-02-26	hcgzu preparation acquisto manxxx - acquisto manxxx