Brad McKuhen
SQL Server DBA, Developer, Architect, Author, Presenter
Tuesday, August 25, 2015
Are remote admin connections enabled?
How do I check if remote admin connections are enabled?
select case when value = 1 then 'Yes' else 'No' end as [Remote Admin Connections Enabled] from sys.configurations where name = 'remote admin connections' ;
Tuesday, August 18, 2015
Check if database mail is enabled
How do I check if database mail is enabled?
select case when value = 1 then 'Yes' else 'No' end as [Database Mail Enabled] from sys.configurations where name = 'Database Mail XPs' ;
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)