[dba-SQLServer]Linked server definitions

David Emerson davide at dalyn.co.nz
Tue Jun 17 13:46:11 CDT 2003


Ahhhhh.  Thanks Francisco.  Couldn't see it for looking.

David

At 17/06/2003, you wrote:
>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
>
>
>_______________________________________________
>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