WHEN s.provider = 'SQLNCLI' THEN 'SQL Server Native Client' WHEN s.provider = 'SQLOLEDB' THEN 'SQL Server OLE DB Provider' ...

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 ...

I don't know if we have a config incorrect or what.<BR><BR>We have a stored procedure that does some selects to import data from tables and views on a linked SQL Server.<BR><BR>Lately, every once in a ...