sys.soap_endpoints (Transact-SQL)
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 'http://tempuri.org' if DEFAULT was specified instead. |
default_result_schema |
tinyint |
The default value of the SCHEMA = option. 0 = NONE 1 = STANDARD |
default_result_schema_desc |
nvarchar(60) |
Description of the default value of the SCHEMA = option. NONE STANDARD |
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. WINDOWS MIXED |
header_limit |
int |
Maximum allowable size of the SOAP header. |
Permissions
In SQL Server 2005 and later versions, 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.