Retrieving nt_username from Sysprocesses

Hi,
We have a stored procedure that returns the nt_username, amongst other
columns, from master.sysprocesses. This works fine under SQL2000 SP2 under
W2K SP4. We are testing W2K3 and find that this information is missing now.
We are testing with SQL2000 SP3 build 818 on W2K3.
Do we need to authorize something in W2K3?
Thanks
Chris Wood
Alberta Department of Energy
CANADA
Try:
select suser_sname(sid) from sysprocesses
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:Odpj8ryQEHA.3140@.TK2MSFTNGP11.phx.gbl...
Hi,
We have a stored procedure that returns the nt_username, amongst other
columns, from master.sysprocesses. This works fine under SQL2000 SP2 under
W2K SP4. We are testing W2K3 and find that this information is missing now.
We are testing with SQL2000 SP3 build 818 on W2K3.
Do we need to authorize something in W2K3?
Thanks
Chris Wood
Alberta Department of Energy
CANADA
|||Tom,
Has this behaviour happened in SQL2000 SP3 or W2K3?
Thanks
Chris
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OiV0iyyQEHA.3580@.TK2MSFTNGP11.phx.gbl...
> Try:
> select suser_sname(sid) from sysprocesses
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:Odpj8ryQEHA.3140@.TK2MSFTNGP11.phx.gbl...
> Hi,
> We have a stored procedure that returns the nt_username, amongst other
> columns, from master.sysprocesses. This works fine under SQL2000 SP2 under
> W2K SP4. We are testing W2K3 and find that this information is missing
now.
> We are testing with SQL2000 SP3 build 818 on W2K3.
> Do we need to authorize something in W2K3?
> Thanks
> Chris Wood
> Alberta Department of Energy
> CANADA
>
|||Chris,
I have a SQL Server 2000 server with build 818 running on both Windows 2000
and Windows 2003 and the nt_username is present in the output of select *
from sysprocesses onboth .
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Rand,
What are the Client network settings on your workstation and the Server
network settings on the server please?
Thanks
Chris
"Rand Boyd [MSFT]" <rboyd@.onlinemicrosoft.com> wrote in message
news:RqUFvYzQEHA.1516@.cpmsftngxa10.phx.gbl...
> Chris,
> I have a SQL Server 2000 server with build 818 running on both Windows
2000
> and Windows 2003 and the nt_username is present in the output of select *
> from sysprocesses onboth .
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>
|||I have SQL 2000 under Windows 2003 and only some users show the nt_username in sysprocesses.
All of the 2000 Clients do (9 of 9) only one of the XP clients do ( 1 of 15 ). Application using BDE/DBNETLIB to connect to server.
Tim S
sql