Deprecated SQL Server Features in SQL Server 2008 R2

Note

For SQL Server 2008 R2, there have been no changes to the content that is listed in this topic.

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

See Also

Concepts

Backward Compatibility