Export (0) Print
Expand All

sys.dm_cryptographic_provider_keys (Transact-SQL)

Returns information about the keys provided by a Extensible Key Management (EKM) provider.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

dm_cryptographic_provider_keys ( provider_id )

provider_id

Identification number of the EKM provider, with no default.

Column name

Data type

Description

key_id

int

Identification number of the key on the provider.

key_name

nvarchar(512)

Name of the key on the provider.

key_thumbprint

varbinary(32)

Thumbprint from the provider of the key.

algorithm_id

int

Identification number of the algorithm on the provider.

algorithm_tag

int

Tag of the algorithm on the provider.

key_type

nchar(256)

Type of key on the provider.

key_length

int

Length of the key on the provider.

When this view is queried it will authenticate the user context with the provider and enumerate all keys visible to the user.

If the user cannot authenticate with the EKM provider, no key information will be returned.

The following example shows the key properties for a provider with the identification number of 1234567.

SELECT * FROM sys.dm_cryptographic_provider_keys(1234567);
GO
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft