Tracking EXE inside the insert trigger using the process ID & SP_W

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hola!

I am trying to track inside the insert trigger, what EXE is creating the
insert using the process ID.

1) If I call from an EXE done using VB6 (lastest patch), I do an SP_WHO2, I
can see in the ProgramName field the exe name.

2) If I call from an EXE done using .NET C# (2003), I do an SP_WHO2, I can
see in the ProgramName field ".net client". But there are many ".net client"
comming form other applications. So, I don't know who is who. I am using
ADO.NET. Which is creating the ".net client".

Do I have to set up some parameter at the connection level?

Can I do this? Am I missing something?

José
 
I believe there is an Application parameter you can set in the connection
string, which should change that.
 
Back
Top