SQL Server interprets <linked-server> to derive the OLE DB provider and the connection attributes that identify the data source to the provider. The other three name parts are interpreted by the OLE ...

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

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