I run a stored proc on my monitoring server that uses the linked server approach to call sprocs on the remote servers.  It requires me to install in the remote...

All interesting comments. My take is a little different. MS SQL and associated components like MSAS and DTS/MSIS are complex tools. Frequently there is no best way...