Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
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) |
Remarks
The sys.dm_cryptographic_provider_properties view is visible to the public.
See Also
Reference
Security Catalog Views (Transact-SQL)
CREATE CRYPTOGRAPHIC PROVIDER (Transact-SQL)
Security-Related Dynamic Management Views and Functions (Transact-SQL)