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