Try setting the [baker].[amcaslocal].[dbo] part to a field say $ServerTableOwner$ and then use EXEC $ServerTableOwner$.[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = 160240 in your AL.. That may prevent the AR Server from removing the server name.. Joe
----- Original Message ---- From: Warren Baltimore <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 2:59:12 PM Subject: Re: SQL Stored procedures ** Yes, I did check that the user was correct (ARAdmin) and that it has permissions. In fact, the stored procedure was authored by ARAdmin! Warren When we first built this procedure, it was running on a db that was on the Local Remedy SQL Server. The difference now is that it is being called from a linked server. When it is called by ARAdmin in the query analyzer using the following syntax, it works fine: EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = 160240 I am calling this from the Local Remedy Server by the way. When Remedy calls it, we have found that the server name [baker] is being dropped from the call..... Warren On 6/2/08, Pavel Guedez <[EMAIL PROTECTED]> wrote: ** Warren when you tested the syntax in query analyzer. Did you log in as ARADMIN?, that for check if you have the right permissions, check this out and if you have the permissions, verify the syntax on procedure (OUTPUT parameters) Pavel ----- Original Message ---- From: Joe DeSouza <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 1:42:06 PM Subject: Re: SQL Stored procedures ** Does the ARSystem database user aradmin have permissions to the store proceedure? Does aradmin have permissions to the DB link and any other resource that the stored proceedure may be using? Joe ----- Original Message ---- From: Warren Baltimore <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Monday, June 2, 2008 12:42:33 PM Subject: Re: SQL Stored procedures ** EXEC [baker].[amcaslocal].[dbo].[AA_Disadvantaged_WordSearch_01] @lineup_input_appl_id = $APPL_PERSON_ID$ I'm using the same syntax in all of my other procedure calls. The difference here being this is the only one that exists on a remote server. I've tested the syntax in query analyzer. I'm not sure what else it could be (syntax wise). Thanks for the help! Warren On 6/2/08, Dave Saville <[EMAIL PROTECTED]> wrote: Warren Are you sure you have the correct invocation syntax in Remedy? ISTR it is a bit picky. -- Regards Dave Saville _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ -- Warren R. Baltimore II Remedy Developer UW Medicine IT Services School of Medicine University of Washington Box 358220 1325 Fourth Ave, Suite 2000 Seattle, WA 98101 The opinions expressed in this e-mail are in no way those of the University of Washington, or the State of Washington. They are my own. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"