sysprocesses::nt_username Empty

  • And as would be expected, this is as accurate as your DNS is. If systems aren't auto-registering properly (or DHCP in Windows 2000 isn't handling it properly for clients that can't themselves) and/or if the WINS-R lookups aren't setup, then you will have some holes. Also, keep in mind the IP isn't in sysprocesses. You'll have to use a trace or something of that sort to capture the IP as they connect (though I believe it captures the hostname which can be forged).

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply