Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  NT User info not showing up in sysprocesses

Author  Topic  sherrer 64 Posts Posted - 2003-01-30 : 21:57:36 I am using SQL Server 7.0 I have an application logging in under an SQL server account. For the longest time I have had no trouble with a trigger for an audit table that selects the nt_username out of sysprocesses for the current spid. Lately, I have been getting blanks in the sysprocesses table for users that have logged into the application. I can see no pattern for this at all, but more and more accounts are having this problem. Can anyone clue me in on what may be happening? I have some users that may be logged on multiple times, sometimes their NT user info shows up, some times it doesn't. Kevin