Deprecated SQL Server Features in SQL Server 2008 R2
Notes
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 |
Windows Communications Foundation (WCF) or ASP.NET |
Native XML Web Services |
22 |
|
Data Programmability |
Windows Communications Foundation (WCF) or ASP.NET |
Native XML Web Services |
23 |