Επεξεργασία

Κοινή χρήση μέσω


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