This topic has not yet been rated - Rate this topic

sys.dm_cryptographic_provider_keys (Transact-SQL)

SQL Server 2008 R2

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


dm_cryptographic_provider_keys ( provider_id )

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

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions