November 1, 2004 at 10:36 pm
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
November 2, 2004 at 4:55 am
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.
November 2, 2004 at 5:58 pm
Thanks for that. One less obstruction.
Steve
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy