Deprecated SQL Server Features in SQL Server 2008

SQL Server Setup

This topic describes the deprecated features that are still available in SQL Server 2008. These features are scheduled to be removed in a future release of SQL Server. Deprecated features should not be used in new applications.

Features Not Supported in the Next Version of SQL Server

The following SQL Server Database Engine features will not be supported in the next version of SQL Server. Do not use these features in new development work, and modify applications that currently use these features as soon as possible. The Feature name column appears in trace events as the ObjectName, in performance counters and sys.dm_os_performance_counters as the instance_name. The Feature ID appears in trace events as the ObjectId.

Category Deprecated feature Replacement Feature name Feature ID

SQL Server services

ADHelper service

None

ADHelper

Data Programmability

SOAP/HTTP endpoints with CREATE ENDPOINT (Transact-SQL) and ALTER ENDPOINT (Transact-SQL)

Windows Communications Foundation (WCF) or ASP.NET

Native XML Web Services

21

Data Programmability

sys.soap_endpoints (Transact-SQL)

Windows Communications Foundation (WCF) or ASP.NET

Native XML Web Services

22

Data Programmability

sys.endpoint_webmethods (Transact-SQL)

Windows Communications Foundation (WCF) or ASP.NET

Native XML Web Services

23