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_sessions (Transact-SQL)

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 open sessions for a cryptographic provider.

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

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.

Community Additions

ADD
Show:
© 2015 Microsoft