Skip to main content
How can we help?
< All Topics
Print

Non-existing default database for user

If a user is having a default database set, but this database does not exist anymore, this alert will be thrown.

To query the Performance Store database for users where the default database does not exist, use:

select s.server_name, s.member_name, s.default_database_name, s.default_database_exists
from dbo.v_server_security s with (nolock)
left join dbo.v_databases d on d.server_name = s.server_name and d.database_name = s.default_database_name and d.state_desc = 'ONLINE'
left join dbo.v_servers s1 on s1.server_name = s.server_name
where d.server_name is null
and s.discovered = 1
and s.default_database_name is not null
and s.default_database_exists = 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