Detect all NtUserName

Hi,
I have a problem to find out every NtUserName in my SP that take
information from Sysprocesses. Some NtUserName columns ary empty and I have
much hard work to discover who's that guy connect in my Database.
I think to match another utility throught xp_cmdshell to run an get
NtUserName by hostname parameter, but I didn't find out any DOS utility to
easy display that information.
Please, I hope some help .
Thanks!
Krisnamourt
If that wont tell you the appropiate names
Select loginame from sysprocesses
you dont actually work with integrated security, dont you ?
If you want to get the username even the User connects with Sql Server
authentification that would be a kind of hack, to put the WIndowsUser from
your application in the connectionstring to read that Conenction property
from SQLServer.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Krisnamourt Correia via droptable.com" <forum@.nospam.droptable.com>
schrieb im Newsbeitrag
news:fffd09ac4f6d4a96a909e4f78a47e8d8@.droptable.co m...
> Hi,
> I have a problem to find out every NtUserName in my SP that take
> information from Sysprocesses. Some NtUserName columns ary empty and I
> have
> much hard work to discover who's that guy connect in my Database.
> I think to match another utility throught xp_cmdshell to run an get
> NtUserName by hostname parameter, but I didn't find out any DOS utility to
> easy display that information.
> Please, I hope some help .
> Thanks!
> Krisnamourt
|||Our Client conections has been in BDE conection by Delphi program. This use
one connection login. I have a SP to help some issues to controll locks and
other needs, but in all most that connection, the ntusername come blank and
other with the real ntusername, no different that library are Named Pipe or
TCP/IP. That information are collected in sysprocesses with hostname, login
and ntusername, but the last is a problem to find out.
I want to ever get NtUserName! Is that a bug's BDE of Delphi?
"Jens Sü?meyer" wrote:

> If that won′t tell you the appropiate names
> Select loginame from sysprocesses
> you don′t actually work with integrated security, don′t you ?
> If you want to get the username even the User connects with Sql Server
> authentification that would be a kind of hack, to put the WIndowsUser from
> your application in the connectionstring to read that Conenction property
> from SQLServer.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "Krisnamourt Correia via droptable.com" <forum@.nospam.droptable.com>
> schrieb im Newsbeitrag
> news:fffd09ac4f6d4a96a909e4f78a47e8d8@.droptable.co m...
>
>
|||No not at all, Windows username is only given if you come along with
integrated security.
Jens SUessmeyer.
"Krisnamourt" <Krisnamourt@.discussions.microsoft.com> schrieb im Newsbeitrag
news:B8F488D8-00EA-4DA3-81FA-B30803AE3377@.microsoft.com...[vbcol=seagreen]
> Our Client conections has been in BDE conection by Delphi program. This
> use
> one connection login. I have a SP to help some issues to controll locks
> and
> other needs, but in all most that connection, the ntusername come blank
> and
> other with the real ntusername, no different that library are Named Pipe
> or
> TCP/IP. That information are collected in sysprocesses with hostname,
> login
> and ntusername, but the last is a problem to find out.
> I want to ever get NtUserName! Is that a bug's BDE of Delphi?
> "Jens Smeyer" wrote:
|||Ok! You mean that I have used inconsistence information...but I Knew that,
because I saw in many times that variable information...so...if in some times
SQL give me...why don't ever?The conecction string is the same for all
users...ok!...but in other hand...I want to use any utility "married " with
XP_CMDSHELL output collection...using temporary table to manipulate that
string...the problem is...what utility?...when i worked wit Windows NT, there
was one resouce kit utility that I passed the host and it answered the
NTUserName...but now my Network is Windows 2000 AD. Do you know some?
"Jens Sü?meyer" wrote:

> No not at all, Windows username is only given if you come along with
> integrated security.
> Jens SUessmeyer.
> "Krisnamourt" <Krisnamourt@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:B8F488D8-00EA-4DA3-81FA-B30803AE3377@.microsoft.com...
>
>
|||Look at this thread, that would be the only chance to get the Windows name
according to SQL Server Auth.
http://groups.google.de/group/micros...2257c40e693afe
Any XP_CMDShell wont work because it is executed on the server and the
server has no information about the User presented on the other side.
HTH, Jens Suessmeyer.
"Krisnamourt" <Krisnamourt@.discussions.microsoft.com> schrieb im Newsbeitrag
news:A137A4EA-6891-43CC-87CC-FAAC1748C197@.microsoft.com...[vbcol=seagreen]
> Ok! You mean that I have used inconsistence information...but I Knew that,
> because I saw in many times that variable information...so...if in some
> times
> SQL give me...why don't ever?The conecction string is the same for all
> users...ok!...but in other hand...I want to use any utility "married "
> with
> XP_CMDSHELL output collection...using temporary table to manipulate that
> string...the problem is...what utility?...when i worked wit Windows NT,
> there
> was one resouce kit utility that I passed the host and it answered the
> NTUserName...but now my Network is Windows 2000 AD. Do you know some?
> "Jens Smeyer" wrote: