Re: HELP..

From: Tobias Thernström (tt@rbam_nospam.se)
Date: 07/10/02 

From: "Tobias Thernström" <tt@rbam_nospam.se>
Date: Wed, 10 Jul 2002 22:32:11 +0200

suser_name() is always NULL for Windows Logins, it is only there for
backwards compability. Always use suser_Sname().

/ Tobias

"Shamim" <shamim.abdul@railamerica.com> wrote in message
news:#w5729EKCHA.2160@tkmsftngp10...
> 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
> > >
> > >
> >
> >
>
>
>