Have any of you tried to execute a DBCC command on a linked server? If so, can you include a code snippet? There are certain functions like DBCC SHOWFILESTATS that I would like to run on all servers in our enterprise, and do not want to have to write something separate on each server.
Please let me know if any of you have tried this.