Have you confirmed that the ARAdmin user has execute permissions to the stored procedure? It would make sense that you would be able to execute the procedure since it would have been created under your account. ARAdmin, however, would have been denied access to the object by default.
Have you tried connecting to the remote database server with the ARAdmin account via Query Analyser and executing the procedure that way? This is probably the easiest way of confirming that the account has permissions to the object. Another idea would be to fire up SQL Profiler to see what is happening with the statement. Profiler catches quite a bit of information from the server, so it might take a few minutes of tweaking some of the criteria to filter, but it should pay off. At the very least, it should show the statement being executed and any errors which might have crept up from the call. Just a few thoughts... Offered humbly... ** 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
