sys.soap_endpoints (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Contains one row for each endpoint in the server that carries a SOAP-type payload. For every row in this view, there is a corresponding row with the same endpoint_id in the sys.http_endpoints catalog view that carries the HTTP configuration metadata.

Column name Data type Description
< inherited columns> For a list of columns that this view inherits, see sys.endpoints (Transact-SQL).
is_sql_language_enabled bit 1 = BATCHES = ENABLED option was specified, meaning that ad-hoc SQL batches are allowed on the endpoint.
wsdl_generator_procedure nvarchar(776) The three-part name of the stored procedure that implements this method.

Names of methods require strict three-part syntax. one, two, or four-part names are not allowed.
default_database sysname The name of the default database given in the DATABASE = option.

NULL = DEFAULT was specified.
default_namespace nvarchar(384) The default namespace specified in the NAMESPACE = option, or '' if DEFAULT was specified instead.
default_result_schema tinyint The default value of the SCHEMA = option.

0 = NONE

default_result_schema_desc nvarchar(60) Description of the default value of the SCHEMA = option.


is_xml_charset_enforced bit 0 = CHARACTER_SET = SQL option was specified.

1 = CHARACTER_SET = XML option was specified.
is_session_enabled bit 0 = SESSION = DISABLE option was specified.

1 = SESSION = ENABLED option was specified.
session_timeout int Value specified in SESSION_TIMEOUT = option.
login_type nvarchar(60) Kind of authentication allowed on this endpoint.


header_limit int Maximum allowable size of the SOAP header.


The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

See Also

Endpoints Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)