Steve,

We use a home grown system (well several of them really) the main one polls each server hourly and pulls back all 'errors' (governed by a 'white/black' list) that have occurred in the last 24hr and send it as an email attachement to the dba group. The same job also brings back agent job errors. We have done it using a mixture of ssis, sql and .net.

Other home growns include distributed and centralised systems. So the information, data and code is distributed but then feeds in to a central repository that can be used for reporting (specific users then access this data via excel).

So there is deffinately a case for both techniques, though personally my option would be to have a solution which merges both.

We also have bought in solutions. Started with SQL Response but it wasnt great and we now use Idera DM, which I have to say SQL Monitor could learn a lot from.

Have a nice weekend, laters :hehe: