sys.dm_cryptographic_provider_properties (Transact-SQL)

sys.dm_cryptographic_provider_properties (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns information about registered cryptographic providers.

Column nameData typeDescription
provider_idintIdentification number of the cryptographic provider.
guiduniqueidentifierUnique provider GUID.
provider_versionnvarchar(256)Version of the provider in the format 'aa.bb.cccc.dd'.
sqlcrypt_versionnvarchar(256)Major version of the SQL Server Cryptographic API in the format 'aa.bb.cccc.dd'.
friendly_namenvarchar(2048)Name supplied by the provider.
authentication_typenvarchar(256)WINDOWS, BASIC, or OTHER.
symmetric_key_supporttinyint0 (not supported)

1 (supported)
symmetric_key_exporttinyint0 (not supported)

1 (supported)
symmetric_key_importtinyint0 (not supported)

1 (supported)
symmetric_key_persistancetinyint0 (not supported)

1 (supported)
asymmetric_key_supporttinyint0 (not supported)

1 (supported)
asymmetric_key_exporttinyint0 (not supported)

1 (supported)
symmetric_key_importtinyint0 (not supported)

1 (supported)
symmetric_key_persistancetinyint0 (not supported)

1 (supported)

The sys.dm_cryptographic_provider_properties view is visible to the public.

Security Catalog Views (Transact-SQL)
Encryption Hierarchy
Extensible Key Management (EKM)
CREATE CRYPTOGRAPHIC PROVIDER (Transact-SQL)
Security-Related Dynamic Management Views and Functions (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft