What sort of connectivity do you have and do you have a list of the servers you need to access? Might be better to do this on the servers and send the info out as it might cause issues if a server wasn't contactable.
You might also look at a monitoring product.
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.
1.sqldatabase backup job failures from all servers Check for msdb.Sys.sysjobs 2.diskspace utilization from all servers You can create linked server for all and query xp_fixeddrives store it in table 3.Logspace utilization from all servers Do you different drive for logspace These need to be generated as single Excel file and send to mailid everday
health report
Posted - 01/04/2013 : 09:46:20
