Muokkaa

Jaa


sp_get_endpoint_certificate (Transact-SQL)

Applies to: SQL Server Azure SQL Managed Instance

Returns a public key of the certificate used for authentication on endpoint of specified type with certificate-based trust configured. Supported types of endpoints are Database Mirroring endpoint (also used for Link feature of Azure SQL Managed Instance) and Service Broker endpoint.

Transact-SQL syntax conventions

Syntax

sp_get_endpoint_certificate [ @endpoint_type = ] endpoint_type
[ ; ]

Arguments

[ @endpoint_type = ] endpoint_type

Type of endpoint for which certificate's public key is required. @endpoint_type is int, and can be one of these values:

Value Endpoint
3 Service Broker
4 Database Mirroring

Values correspond to the endpoint payload types in sys.endpoints system catalog view.

If any other integer value is provided, stored procedure returns NULL.

Return code values

0 (success) or 1 (failure).

Result set

Column name Data type Description
EndpointCertificatePublicKey varbinary Public key of the certificate, in binary format

Remarks

If authentication type configured on the endpoint isn't certificate-based, stored procedure returns error.

Permissions

User must have VIEW permission on the endpoint to execute sp_get_endpoint_certificate.