[dba-SQLServer]Linked server definitions

David Emerson davide at dalyn.co.nz
Mon Jun 16 21:51:49 CDT 2003


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



More information about the dba-SQLServer mailing list