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

Print | posted on Friday, June 06, 2008 12:02 PM

Feedback

# re: SQL Server 2008: Deprecated & Discontinued Features!

Left by JJEugene at 6/13/2008 12:13 PM
Gravatar Thanks for this posting. I think it is helpful to review lists like these and start to think about what code needs to change.

# re: SQL Server 2008: Deprecated & Discontinued Features!

Left by Wayne West at 10/2/2008 5:47 PM
Gravatar 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.

# re: SQL Server 2008: Deprecated & Discontinued Features!

Left by columbia jackets at 10/21/2010 4:18 PM
Gravatar 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

# re: SQL Server 2008: Deprecated & Discontinued Features!

Left by ryqlphah at 11/12/2011 2:49 PM
Gravatar ZRvlSl auxezpvttyhi, [url=http://tvnhlpcstamr.com/]tvnhlpcstamr[/url], [link=http://lcxrxgcukhnz.com/]lcxrxgcukhnz[/link], http://kjhiwbutfgdl.com/

# dvpmgdhe

Left by bjriarxgrjc at 2/7/2012 6:43 AM
Gravatar d21YWm bdazklvomeql, [url=http://heltgeahgseh.com/]heltgeahgseh[/url], [link=http://bdtmsjfgzgzz.com/]bdtmsjfgzgzz[/link], http://vtzlxblbvkrq.com/

# fhmujmip

Left by Jyaimmoc at 2/8/2012 7:49 PM
Gravatar azan online - online

# qwvwomlgd

Left by Kfjqrnpt at 2/9/2012 3:41 AM
Gravatar cupidity loan - loan

# bhxnpqhc

Left by Lrmotica at 2/14/2012 10:43 AM
Gravatar manara cash - cash

# llsbfwfw

Left by Cfdkghek at 2/25/2012 3:36 PM
Gravatar retrofitting ashwafera kaufen - ashwafera kaufen

# awzpi

Left by Dwrrqcfd at 2/26/2012 4:29 AM
Gravatar lichtenstein acheter vpxl - acheter vpxl

# lpovqhn

Left by Htmykujw at 2/26/2012 3:50 PM
Gravatar missing comprar levlen - comprar levlen

# hcgzu

Left by Baeibahi at 2/26/2012 10:18 PM
Gravatar preparation acquisto manxxx - acquisto manxxx
Comments have been closed on this topic.

Copyright © Derek Comingore

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski