Thanks Will....all good ideas, but I actually created the stored procedure as ARAdmin! It's the owner. I have not looked at the profiler though, I'll take a look and see if anything jumps out.
Thanks! Warren On 6/2/08, Will Du Chene <[EMAIL PROTECTED]> wrote: > > ** > > 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]<http://display_enter/?force_room=_MAIL_&[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___ -- 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"