Re: No results from query in some contexts

m.bohse_at_quest-consultants.com
Date: 11/24/05

  • Next message: Iain: "Re: No results from query in some contexts" 
    Date: 24 Nov 2005 07:21:28 -0800

    Iain, under which security context do you execute the stored procedure
    ?
    If you use EXECUTE AS CALLER, maybe your application account doesn't
    have the right permissions.

    Markus

  • Next message: Iain: "Re: No results from query in some contexts"

    Relevant Pages

    • Re: Execute Persmission denied on object sp_OACreate
      ... > I logged in as that user, tried to execute the DTS ... which then launches the DTS package using the sp_OA* procs? ... account is used during proc execution. ... > proxy account to use in the Job Systems tab of SQL Server Agent ...
      (microsoft.public.sqlserver.security)
    • Execute Process Task not failing, but not executing the batch comm
      ... I can execute the following command from the windows "Run" prompt and it ... Might I have something set weird in SQL Server? ... server being by default configured to run as localsystem account, ...
      (microsoft.public.sqlserver.dts)
    • Re: pass stored procedure parameters in asp
      ... In Management Studio, open a new query window, logging in with the bettys ... account and try to execute the procedure. ... procedure and properties) of voidTran stored procedure and other ...
      (microsoft.public.inetserver.asp.general)
    • Re: dts or xp_cmdshell permissions
      ... You could have the users execute the package ... Change the SQL Server or SQL Server Agent Service ... >> Account Without Using SQL Enterprise Manager in SQL Server ...
      (microsoft.public.sqlserver.tools)
    • Re: xp_cmdShell
      ... checkbox under SQL Server Agent properties --> Job ... System) and specify a Windows account for the SQL Agent proxy with the ... > I thought if he has execute permission for my sp, which owner is DBO, that ... If I set the execute permission for 'xp_cmdshell' to my read user I get the ...
      (microsoft.public.sqlserver.programming)