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.

How to fix

Do not use the deprecated FOR SOAP option in CREATE/ALTER ENDPOINT statement and in new development work.e

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.

Effort To Fix
8 hours per issue.
Categories

Deprecated Features, Bugs

Additional Information
Example Test SQL
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