0 out of 2 rated this helpful - Rate this topic

sys.dm_cryptographic_provider_properties (Transact-SQL)

SQL Server 2008

Returns information about registered cryptographic providers.

Column name	Data type	Description
provider_id	int	Identification number of the cryptographic provider.
guid	uniqueidentifier	Unique provider GUID.
provider_version	nvarchar(256)	Version of the provider in the format 'aa.bb.cccc.dd'.
sqlcrypt_version	nvarchar(256)	Major version of the SQL Server Cryptographic API in the format 'aa.bb.cccc.dd'.
friendly_name	nvarchar(2048)	Name supplied by the provider.
authentication_type	nvarchar(256)	WINDOWS, BASIC, or OTHER.
symmetric_key_support	tinyint	0 (not supported) 1 (supported)
symmetric_key_export	tinyint	0 (not supported) 1 (supported)
symmetric_key_import	tinyint	0 (not supported) 1 (supported)
symmetric_key_persistance	tinyint	0 (not supported) 1 (supported)
asymmetric_key_support	tinyint	0 (not supported) 1 (supported)
asymmetric_key_export	tinyint	0 (not supported) 1 (supported)
symmetric_key_import	tinyint	0 (not supported) 1 (supported)
symmetric_key_persistance	tinyint	0 (not supported) 1 (supported)

The sys.dm_cryptographic_provider_properties view is visible to the public.

Updated content
Corrected the name of this view. It was mistakenly listed as sys.dm_provider_properties.
Corrected the data types of the columns, and added the friendly_name column.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions