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