sys.dm_external_provider_certificate_info (Transact-SQL)
Applies to:
SQL Server 2022 (16.x)
Note
This view is introduced in SQL Server 2022 CU1.
Returns information about the Azure cloud certificates used in SQL Server to set up and maintain a Microsoft Entra administrator required to support Microsoft Entra authentication. For more information, see Set up Microsoft Entra authentication for SQL Server.
Column name | Data type | Description |
---|---|---|
Subject | nvarchar(4000) | The subject name of the certificate. |
thumbprint | nvarchar(4000) | Certificate thumbprint. |
expire_date | datetime2 | Certificate expiration date and time. |
is_readable | bit | Indicates whether the certificate is readable for both public and private key. Values are: 1 - Yes 0 - No |
is_missing | bit | Indicates whether the certificate is present in the certificate store. Values are: 1 - Yes 0 - No |
Permissions
Principals must have the VIEW SERVER SECURITY STATE permission.
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.
See also
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