Hi all. One of our large SQL applications is pre-.Net (i am told "probably" written in C++) and uses an ODBC DSN to make connections to the sql server. The connection info held in sysprocesses for this application's connections does not contain a hostname (or application name)
Is there any other way to get this info? Perhaps doing something with the net address?
I am talking here about a sql 2005 server (although it was no different when we were still on 2000).
I had a nasty blocking issue this morning and felt rather foolish saying that i could not tell where the rougue connection (which had held a transction open for nearly a day!) was coming from, although i could tell the developers "If you find the server then look in Tasdk Manager for client process ID x!". Through trial and error, this eventually worked.
If anyone knows how I might find out the source computer for a connection which does not present hostname, i would be very grateful to hear from them.