Discontinued SQL Server Features in SQL Server 2008

This topic describes features that are no longer available in SQL Server 2008.

Discontinued SQL-DMO from Katmai Express Installation

SQL-DMO for SQL Server has been removed from SQL Server 2008 Express. We recommend that you modify applications that currently use this feature as soon as possible. If you must support SQL-DMO for SQL Server Express, install the Backward Compatibility Components from the SQL Server 2005 feature pack from the Microsoft Download Center. Use SQL Server Management Objects (SMO) for new development work.

Discontinued Option for Web Assistant

The sp_configure option to enable Web Assistant has been removed from SQL Server 2008. We recommend that you use Reporting Services instead.

Surface Area Configuration Tool

The Surface Area Configuration tool (SAC) for SQL Server has been removed from SQL Server 2008. Replacement functionality in this release is as follows:

Category

Discontinued feature

Replacement

Tools

Surface Area Configuration tool

The Surface Area Configuration tool is discontinued for SQL Server 2008. The following table shows what you can use to configure settings, options, and component features in this release.

Settings and component featuresHow to configure
Protocols, connection, and startup optionsUse SQL Server Configuration Manager.
Database Engine featuresUse Policy-Based Management, the property settings in SQL Server Management Studio, or sp_Configure.
Analysis Services featuresUse the property settings in SQL Server Management Studio.
Reporting Services - EnableIntegrated Security propertyUse the property settings in SQL Server Management Studio.
Reporting Services - "Schedule events and report delivery" and "Web service and HTTP access"Edit the RSReportServer.config configuration file.
Command line optionsNo support in this release.
SOAP and Service Broker endpointsUse CREATE ENDPOINTand ALTER ENDPOINT.

Discontinued Command Prompt Parameters for SQL Server Setup

The following table shows Setup command prompt parameters from earlier versions of SQL Server that are not supported in SQL Server 2008.

Discontinued parameter

Replacement parameter

ADDLOCAL

/ACTION=Uninstall and /FEATURES

DISABLENETWORKPROTOCOLS

/TCPENABLED for TCP/IP1

DISABLENETWORKPROTOCOLS

/NPENABLED for Named Pipes1

INSTALLSQLDATADIR

/SQLUSERDBDIR

/SQLUSERDBLOGDIR

/SQLBACKUPDIR

/SQLTEMPDBDIR

/SQLTEMPDBLOGDIR

REINSTALL

No equivalent in this release.

REINSTALLMODE

No equivalent in this release.

REMOVE

/ACTION=Uninstall and /FEATURES

SAMPLEDATABASE

No equivalent in this release.

SAVESYSDB

No equivalent in this release.

SKUUPGRADE2

No equivalent in this release.

UPGRADE

/ACTION=Upgrade and /FEATURES

USESYSDB

No equivalent in this release.

1These parameters are valid only for installation. For more information, see How to: Install SQL Server 2008 from the Command Prompt.

2Starting SQL Server 2008, specify /Action=EditionUpgrade, to upgrade an existing edition of SQL Server to a different edition any time without using the original installation media. For more information about the supported version and edition upgrades, see Version and Edition Upgrades.