| title | sys.soap_endpoints (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 06/10/2016 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine | ||||
| ms.reviewer | |||||
| ms.technology | system-objects | ||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | f50dcbfc-02ed-4a19-9c07-c78a5a1b3224 | ||||
| author | stevestein | ||||
| ms.author | sstein | ||||
| manager | craigg |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
[!INCLUDEssNoteDepFutureAvoid]
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. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Endpoints Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)