sys.soap_endpoints (Transact-SQL)

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.

See Also

Reference

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

Help and Information

Getting SQL Server 2005 Assistance