Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

sys.dm_cryptographic_provider_properties (Transact-SQL)

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.