SA0221 : The FOR SOAP option in CREATE/ALTER ENDPOINT statement is deprecated

The topic describes the SA0221 analysis rule.

Message

The FOR SOAP option in CREATE/ALTER ENDPOINT statement is deprecated

Description

The rule checks T-SQL code and reports usages of the CREATE/ALTER ENDPOINT statements for using the deprecated FOR SOAP option.

Native XML Web Services (SOAP/HTTP endpoints) is removed beginning in SQL Server 2012.

Scope

The rule has a Batch scope and is applied only on the SQL script.

Parameters

Rule has no parameters.

Remarks

The rule does not need Analysis Context or SQL Connection.

Categories

Deprecated Features, Bugs

Additional Information
Example Test Script
SQL
 1CREATE ENDPOINT FooEndpoint
 2STATE = Started
 3AS HTTP
 4(
 5    PATH = '/Foo',
 6    AUTHENTICATION = (INTEGRATED),
 7    PORTS = (CLEAR), CLEAR_PORT = 8080,
 8    SITE = '*'
 9)
10FOR SOAP
11(
12    WEBMETHOD 'FooMethod'(NAME = 'FooDatabase.FooSchema.uspFoo'),
13    WSDL = DEFAULT,
14    DATABASE = 'FooDatabase',
15    NAMESPACE = DEFAULT
16);
17
18ALTER ENDPOINT FooEndpoint
19FOR SOAP
20(
21    ADD WEBMETHOD 'Foo2Method'(NAME = 'FooDatabase.FooSchema.uspFoo2')
22);

Analysis Results

  Message Line Column
1 SA0221 : The FOR SOAP option in CREATE/ALTER ENDPOINT statement is deprecated. 10 4
2 SA0221 : The FOR SOAP option in CREATE/ALTER ENDPOINT statement is deprecated. 19 4
See Also

Other Resources