Export (0) Print
Expand All

sys.dm_cryptographic_provider_sessions (Transact-SQL)

Returns information about open sessions for a cryptographic provider.


sys.dm_cryptographic_provider_sessions(session_identifier)

session_identifier

An integer indicating the sessions to be returned.

0 = Current connection only

1 = All cryptographic connections

Column name

Data type

Description

provider_id

int

Identification number of the cryptographic provider.

session_handle

varbytes(8)

Cryptographic session handle.

identity

nvarchar(128)

Identity used to authenticate with the cryptographic provider.

spid

short

Session ID SPID of the connection. For more information, see @@SPID (Transact-SQL).

The sys.dm_cryptographic_provider_sessions view is visible to the public for the current connection. To view all cryptographic connections, you must have the CONTROL server permission.

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

Community Additions

ADD
Show:
© 2014 Microsoft