Re: Stored Procedure Owner Issue

From: Raul (raul_at_nothere.com)
Date: 02/11/05 

Date: Fri, 11 Feb 2005 06:39:06 -0800

Thanks for the prompt response. I really appreciate it.

Raul

"Aaron Weiker" wrote:

> Raul wrote:
> > I have several stored procedures and tables that are owned by me (I'm not a
> > system administrator). The stored procedures work when executed from query
> > analyzer but I can't run these stored procedures from a scheduled job.
> >
> > I'm assuming it's because the owner names for the stored procedures and
> > tables are not "dbo". If this is the case, what are my options? Do I need
> > to change the owner name for these objects, or is there another way?
>
> In order to execute these jobs you have a couple options. In the job or
> job step you can have the jobs run under your account. Or you can prefix
> your name with the stored procedure. For example let's assume your db
> login is "raul" and the stored procedure is "test_proc", then your
> execute statement would look like "EXEC raul.test_proc".
>
> --
> Aaron Weiker
> http://aaronweiker.com/
> http://www.sqlprogrammer.org/
>

Relevant Pages

  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.sqlserver.server)
  • Sybase, JDBC, AutoCommit, DDL IN TRAN
    ... having executing Sysbase stored procedures via JDBC. ... stored procedure which contains DDL and with AutoCommit set to false I ... The explanation for this behaviour I have found is that the JDBC ... I need to be able to set AutoCommit to false and execute multiple ...
    (comp.lang.java.databases)
  • Re: Sybase, JDBC, AutoCommit, DDL IN TRAN
    ... > having executing Sysbase stored procedures via JDBC. ... > stored procedure which contains DDL and with AutoCommit set to false I ... > The explanation for this behaviour I have found is that the JDBC ... > I need to be able to set AutoCommit to false and execute multiple ...
    (comp.lang.java.databases)
  • Re: Records lost in an ADOStoredProc
    ... Use a thread to fire off the stored procedures so that your application ... Let's suppose it updates ... > the CacheSize is set to 1; it is worse when I increase the CacheSize. ... > I don't need to show records, only to execute the store procedure. ...
    (borland.public.delphi.database.ado)
  • Re: call Stored procedure with no params
    ... All stored procedures are exposed as methods of the Connection ... This means you can execute a procedure "Fred" like this: ... so you have parameters (most SPs do). ... Where 5522.22 is a non-string parameter value. ...
    (microsoft.public.data.ado)
Loading