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