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: [email protected] > 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: [email protected] > 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
