sys.soap_endpoints (Transact-SQL)
Applies to: 
SQL Server
This feature will be removed in a future version of 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 https://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
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Endpoints Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for