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

sys.cryptographic_providers (Transact-SQL)

Returns one row for each registered cryptographic provider.

Column name

Data type

Description

provider_id

int

Identification number of the cryptographic provider.

name

sysname

Name of the cryptographic provider.

guid

uniqueidentifier

Unique provider GUID.

version

nvarchar(50)

Version of the provider in the format 'aa.bb.cccc.dd'.

dll_path

nvarchar(512)

Path to DLL that implements the Extensible Key Management (EKM) Application Program Interface (API).

is_enabled

bit

Whether the provider is enabled on the server or not.

0 = not enabled (default)

1 = enabled

The sys.cryptographic_providers view is visible to the public.

In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.