Deprecated and unsupported features in SQL Server 2008

Everyone is waiting for the new features of Microsoft SQL Server 2008 to appear, but we should first know what is not recommended (deprecated) and unsupported (discontinued) features. The "Not recommended" feature refers to features that appear in legacy SQL Server but will no longer be recommended in future versions of SQL Server and will be removed from future releases. "Unsupported" functionality refers to features that do not appear in SQL Server 2008. It is important to understand the specifics of these features before migrating to SQL Server 2008.

Features that are not recommended and unsupported can be found in the backward-compatible online documentation in MSDN. Here are a few of the major aspects that contain a number of compatibility issues:

1.Database Engine

2.Analysis Services

3.Integration Services

4.Reporting Services

5.Replication

6.full-text Search

In addition to these "not recommended" and "unsupported" features, there are many disruptive changes and behavioral changes in the products. A destructive change would make a script in a previous version of SQL Server impossible to run. A change in behavior will affect how a feature in SQL Server works. It is strongly recommended that you refer to the documentation before you upgrade to SQL Server 2008, or use the upgrade recommendations tool. This is a tool to analyze the current SQL Server installation and generate a report that prompts you to fix problems before and after the upgrade.