Posted by pigeon on 06/16/05 06:36

"serge" wrote:
> 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

Well.. they are logging in over the internet.. So even if i know the
computer name, it will not help me that much (since there are hundreds
and hundreds of people logging in all the time).

Also, will the user be listed in active connections evey though his
login fails? or if he logs in and logs out very quickly? I believe his
software islogging in and out very quickly (many many many times a
second).


What do you�ll think?

thanks!
Lee

[Back to original message]