Skip to main content
< All Topics
Print

SA user not disabled

It is advised to disable the sa user so it is not possible to login with the sa user.

To query the Performance Store database for servers where the SA user has not been disabled, use:

select s.*
from dbo.v_server_security s
inner join dbo.v_servers v on v.server_name = s.server_name
where s.is_sa = 1
and s.is_disabled = 0

The alert will be visible on theĀ Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents