Hugo Kornelis (4/12/2013)

---

PurpleLady (4/12/2013)

---

Actually deprecated does not mean removed - it means currently supported but will be removed in future versions. So SOAP is a valid type.

No, it is not. SOAP was deprecated in SQL Server 2008, and removed in SQL Server 2012. That may be unusual (normally deprecated features are kept around for a while), but it is true. The documentation Steve links to in the explanation is correct, the conflicting information found by Kapil_kk is incorrect.

Proof:

SELECT @@VERSION;

-- Code copied from SQL 2008 version of Books Online

CREATE ENDPOINT sql_endpoint

STATE = STARTED

AS HTTP(

PATH = '/sql',

AUTHENTICATION = (INTEGRATED ),

PORTS = ( CLEAR ),

SITE = 'SERVER'

)

FOR SOAP (

WEBMETHOD 'GetSqlInfo'

(name='master.dbo.xp_msver',

SCHEMA=STANDARD ),

WEBMETHOD 'DayAsNumber'

(name='master.sys.fn_MSdayasnumber'),

WSDL = DEFAULT,

SCHEMA = STANDARD,

DATABASE = 'master',

NAMESPACE = 'http://tempUri.org/'

);

GO

Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)

Dec 28 2012 20:23:12

Copyright (c) Microsoft Corporation

Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Msg 7878, Level 16, State 1, Line 2

This "CREATE ENDPOINT" statement is not supported on this edition of SQL Server.