This script will test the connection for each linked server defined. This script will accept an input of a server name. If no name is passed, the script will default to the current computer name. This ...
WHEN s.provider = 'SQLNCLI' THEN 'SQL Server Native Client' WHEN s.provider = 'SQLOLEDB' THEN 'SQL Server OLE DB Provider' ...