Posted by serge on 06/16/05 03:16

One thing you can do to help with your task:

In your SQL EM check the Current Connections and search for the IP
address. When you find the IP address you will also have the SPID, this
can show you the T-SQL statement being run.

Also if you know the IP address, you can find out the computer name.
You find out the computer name, you can find out the user(s) using those
computers.


"pigeon" <UseLinkToEmail@dbForumz.com> wrote in message
news:4_805276_8ad527d329c64023e6bc7f994748bbb8@dbforumz.com...
> I have 2 users that their client software must be going crazy.. they
> are sending packets every .02 seconds to the db server... I know this
> because I stuck a sniffer on teh traffic.. but now i just need to know
> what user is doing this (all traffic is encrypted.. so i couldn't
> sniff out that.. i could only get an IP).
>
> any ideas?
>
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
http://www.dbforumz.com/General-Discussions-find-user-packet-02-sec-MS-SQL-ftopict232446.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
http://www.dbforumz.com/eform.php?p=805276

[Back to original message]