Export (0) Print
Expand All

sys.cryptographic_providers (Transact-SQL)

Returns one row for each registered cryptographic provider.

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

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft