Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sys.dm_cryptographic_provider_properties (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Returns information about registered cryptographic providers.

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

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.

Community Additions

ADD
Show:
© 2015 Microsoft