Linked Server

• info 58414

  Hall of Fame

  Points: 3386

  More actions

  November 24, 2016 at 4:53 am

  #315193

  Hi,

  how can I find out which driver a linked server uses. We have 2 Oracle OLEDB drivers installed (11 and 12), and we would like to know which driver is being used. Is this information in the registry - or in a config file?

  Regards

  Nicole

  🙂

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  November 24, 2016 at 5:18 am

  #1914393

  Nicole

  If you query sys.servers, you should find the information you need in the provider or provider_string column.

  John