Re: Stored Procedure Owner Issue
From: Aaron Weiker (aaron_at_sqlprogrammer.org)
Date: 02/11/05
- Next message: Vincel2k2: "How do I copy a file using xp_cmdshell"
- Previous message: Nick: "SQL date Format Query"
- In reply to: Raul: "Stored Procedure Owner Issue"
- Next in thread: Raul: "Re: Stored Procedure Owner Issue"
- Reply: Raul: "Re: Stored Procedure Owner Issue"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 11 Feb 2005 09:29:30 -0500
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/
- Next message: Vincel2k2: "How do I copy a file using xp_cmdshell"
- Previous message: Nick: "SQL date Format Query"
- In reply to: Raul: "Stored Procedure Owner Issue"
- Next in thread: Raul: "Re: Stored Procedure Owner Issue"
- Reply: Raul: "Re: Stored Procedure Owner Issue"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
