sys.sp_get_endpoint_certificate

Description

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 Type of endpoint for which certificate’s public key is required.

Syntax

sp_get_endpoint_certificate [ @endpoint_type = ] endpoint_type
[ ; ]