Posted by Erland Sommarskog on 12/23/05 00:19

Razvan Socol (rsocol@gmail.com) writes:
> Hmm... you are right. Earlier, I tried using Management Studio Express
> (Nov CTP) on a SQL Server 2000 server and I was able to modify the
> properties of a linked server, if it is using a OLE DB Provider
> (including the OLE DB Provider for Oracle and for ODBC Drivers).
> However, if I connect to a server running SQL Server 2005, the
> properties are read-only.

That sonds reasonable. I got a bit puzzled when you talked about direct
update to the syservers table, as in SQL 2005, there are no system tables
visible for direct update - sysservers and all the others are now views
only.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Connection pooling
• Prev in forum: Re: Size of data-set passed back by a select
• Thread view: Re: Can't edit Linked Server General Properties after saving

[Reply to this message]