HELP..

From: Shamim (shamim.abdul@railamerica.com)
Date: 07/10/02 

From: "Shamim" <shamim.abdul@railamerica.com>
Date: Wed, 10 Jul 2002 15:19:58 -0500

I tried by making the owner of the job as 'sa' and starting the job manually
and scheduled ...both times suser_name() is NULL.

Pls Help

Thanks
Shamim

"Aaron Bertrand [MVP]" <aaronATaspfaq.com> wrote in message
news:ufxlOGEKCHA.2592@tkmsftngp08...
> Well, first things first... did you try it?
>
> --
> www.aspfaq.com / www.perfhound.com
>
>
>
>
> "Shamim" <shamim.abdul@railamerica.com> wrote in message
> news:eVK55$DKCHA.2604@tkmsftngp08...
> > HI All,
> > SQL SERVER 7.0
> >
> > I created a SQL job which executes a stored procedure. Owner of the job
is
> > 'dbadmin',
> > If i use SUSER_NAME() inside my stored procedure - what will be the
value
> > ???
> >
> > Thanks
> > Shamim
> >
> >
>
>

Relevant Pages

  • VB-> ADO -> ORACLE
    ... I have a oracle procedure which executes a query to access external ... have permissions to run the external query in the stored procedure) i am ... when run from sqlplus both user1 and owner can execute the stored procedure ...
    (microsoft.public.data.ado)
  • Re: Is there a way to determine who created a stored procedure?
    ... determine who created a stored procedure? ... owner would reveal the answer, but the owner is by default always the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Edit System Stored Procedure, i.e. sp_helpdb
    ... Perhaps that bug only show itself if you have an owner of a database that doesn't exist in syslogins? ... Tibor Karaszi, SQL Server MVP ... > The Installation wizard uses a Stored Procedure on the SQL server called ...
    (microsoft.public.sqlserver.server)
  • Re: User names
    ... > With SP3 will tables created by upsizing from access also be dbo owned as ... >>dbo by default. ... byjust specifically giving the owner name in QA. ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Cannot perform BULK INSERT even though the account is a bulkadmin
    ... We have a stored procedure that dynamically constructs a BULK INSERT ... The account that executes this stored ... procedure is not the DB owner or table owner, ...
    (microsoft.public.sqlserver.security)