Export (0) Print
Expand All

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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft