You have to define on SQL server Enterprise Manager a linked server - see SQL manual.
ciao Luisa Carena Gestione Postazioni Periferiche e Asset SGS BP Gruppo Banco Popolare di Verona e Novara via Negroni 12 - 28100 Novara Tel: 0321-663995 Email: [EMAIL PROTECTED] Brian Gillock <[EMAIL PROTECTED]> - 25/06/2008 17.31 Inviato da: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> Per favore, rispondere a arslist@ARSLIST.ORG Per: arslist@ARSLIST.ORG CC: Oggetto: Re: Push to External DB ** Thank you Guillaume, but I looked at that and am not finding how to specify the external server. The docs made it sound like you could do that too, and I’ve been looking. I’m guessing there is some kind of configuration required to be able to specify the external DB. Can you point me in the right direction please? Thanks! Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault Sent: Wednesday, June 25, 2008 8:23 AM To: arslist@ARSLIST.ORG Subject: Re: Push to External DB ** A direct SQL statement from a filter should work, provided the aradmin account in the Remedy database has access/permissions to the other database Guillaume -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Brian Gillock Sent: Wed 06/25/08 11:05 AM To: arslist@ARSLIST.ORG Subject: Push to External DB Hey Listers, I'm hoping this is an easy question that only I don't know the answer to. Is there a way to push data into an external database (SQL Server 2005) without using a view form or web service? I don't want to use a view form because of the maintenance associated with it. Thanks! Brian _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ---------------------------------------------------------------------------------------------------------------------------- La presente comunicazione e' destinata esclusivamente al soggetto indicato piu' sopra quale destinatario o ad eventuali altri soggetti autorizzati a riceverla. Essa contiene informazioni strettamente confidenziali e riservate, la cui comunicazione o diffusione a terzi e' proibita, salvo che non sia stata espressamente autorizzata.Se avete ricevuto questa comunicazione per errore, Vi preghiamo di darne immediata comunicazione al mittente e di cancellarne ogni evidenza dai Vostri supporti. ----------------------------------------------------------------------------------------------------------------------------------------
