Does "SQL Server" linked server use OLEDB provider?

• sdoughty

  Say Hey Kid

  Points: 680

  More actions

  November 1, 2004 at 10:36 pm

  #102257

  Hi,

  When I create a linked server using Enterprise Manager, I can choose to say it's an SQL Server, and just put the server name in.  Otherwise, I can explicitly say to use the "Microsoft OLE DB Provider for SQL Server", and give the linked server a nice alias.

  I am recommending that my company change from using the "SQL Server" option to using the full provider so that we can have the same alias across dev, uat and prod environments.

  Question is, is there any performance benefit over just choosing "SQL Server", or does it just use the same OLE DB provider anyway?

  Thanks,

  Steve

• jordanac

  Hall of Fame

  Points: 3653

  More actions

  November 2, 2004 at 4:55 am

  #528594

  Hi ,

  Yes they both will use SQLOLEDB. You can see this by a query on sysservers in Master.

  SELECT     srvproduct, providername, srvname

  FROM         sysservers

   

   

  
  Andy.

• sdoughty

  Say Hey Kid

  Points: 680

  More actions

  November 2, 2004 at 5:58 pm

  #528700

  Thanks for that. One less obstruction.

  Steve