Lists the security services that are active for the session.
show_sec_services()
Shows that the user’s current session is encrypting data and performing replay detection checks:
select show_sec_services()
encryption, replay_detection
Use show_sec_services to list the security services that are active during the session.
If no security services are active, show_sec_services returns NULL.
SQL92 – Compliance level: Transact-SQL extension.
Any user can execute show_sec_services.
Functions is_sec_service_on
