[dba-SQLServer]Linked server definitions

Francisco Tapia my.lists at verizon.net
Tue Jun 17 11:04:56 CDT 2003


To click on the linked server you'll need to be in a session of Enterprise
Manager, there click on the security tab, then Linked servers...

-Francisco
http://rcm.netfirms.com/

On Monday, June 16, 2003 7:51 PM [GMT -8],
David Emerson <davide at dalyn.co.nz> wrote:

: Thank Chris.  I was aware of that but it doesn't give the properties
: as discussed in BOL.
:
: David
:
: At 16/06/2003, you wrote:
:
:: Not sure if this is what you're after, but if you run the Stored
:: Procedure sp_linkedservers in Query Analyzer you'll get a list of
:: currently linked servers.
::
:: Chris Mackin
:: Denver Database Consulting, LLC
:: www.denverdb.com
::
:: -----Original Message-----
:: From: dba-sqlserver-bounces at databaseadvisors.com
:: [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of David
:: Emerson
:: Sent: Monday, June 16, 2003 6:28 PM
:: To: dba-SQLServer at databaseadvisors.com
:: Subject: [dba-SQLServer]Linked server definitions
::
::
:: SQL2000
::
::
:: In BOL in the topic "Configuring OLE DB Providers for Distributed
:: Queries" it says under "
:: OLE DB Provider Options"
:: The OLE DB provider options for managing distributed queries are set
:: using SQL Server Enterprise Manager. In the left pane of SQL Server
:: Enterprise Manager, right-click a linked server definition that uses
:: the OLE DB provider for which you want to set the properties. On the
:: General tab, click Options, and then set the properties.
::
:: I can't find where the list of linked server definitions are so that
:: I can right Click on them.  Can anyone let me know more specifically
:: where I am supposed to be looking on the left hand pane?
::
::
:: Regards
::
:: David Emerson
:: DALYN Software Ltd
:: 25b Cunliffe St, Johnsonville
:: Wellington, New Zealand
:: Ph/Fax (877) 456-1205
::
::
::
:: _______________________________________________
:: dba-SQLServer mailing list
:: dba-SQLServer at databaseadvisors.com
:: http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
:: http://www.databaseadvisors.com
:
: _______________________________________________
: dba-SQLServer mailing list
: dba-SQLServer at databaseadvisors.com
: http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
: http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list