Home Forums Products and Books Third Party Products Idera SQL Diagnostic Manager RE: SQL Diagnostic Manager
AKP
SSCommitted
Points: 1753
More actions
October 12, 2012 at 2:28 pm
#1548835
You can do this way:
This is one time effort and prepare the script for all servers in same way.
update MonitoredSQLServers set MaintenanceModeEnabled = 1 where InstanceName = 'ServerName'
Thanks,
Ashok