Determining the Status of Security Services

Determine whether security services are enabled for the current session, by using show_sec_services

In this 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)