data-konzept

'It is not uncommon as servers get older to have more than a handful of linked servers. And these linked server could point to a variety of sources, requiring a variety of specific drivers to be loaded onto your instance. Do you know all the drivers that are installed on your servers right now? Probably not.

Having a script to quickly check each definition would sure be nice, right?'...

http://thomaslarock.com/2016/03/sql-server-linked-server-connection-test/