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 Sets
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.
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru