I don't know about you but our data warehouses and loading servers contain a lot of linked server connections to various desperate system databases. Sometimes following a processing failure I find it useful to quickly test each of the links to aid diagnosis of a situation.
I hope this script is helpful to you as well.
Copy, paste, execute 🙂
Comments welcome. Thanks