Determining the status of security services

To determine whether security services are enabled for the current session, use show_sec_services. In the following example, the results indicate that unified login is enabled, and, therefore, so are the security services:

select show_sec_services()
 go
------------------------------------------------------
unifiedlogin
(1 row affected)