Posted by Razvan Socol on 12/20/05 09:30

After looking at this thing a little bit more, I noticed that the
"Product name", "Data
source", etc properties can always be modified for any OLE DB Provider,
including "Microsoft OLE DB Provider for SQL Server". So, if it's
important for you to modify those properties (without dropping and
recreating the linked server), you shoud try creating a linked server
using this OLE DB Provider (select "Other data source", instead of "SQL
Server"). However, I guess that there may be some other differences
between the two methods.

Razvan

[Back to original message]