IP Address of updater of DB

I'm currently fighting a SQL Insertion bandit. I have triggers in place that have thwarted every effort that the person has tried.

I'd like to be able to add the IP address of the offending person to my log table. Problem is, I don't know where the IP address value would come from inside my triggers.

For instance, at the time of the discovery, i write a log file that says an invalid attempt to update table XXXX occured at MMD:YYYY @ HH:MM:SS, but I would REALLY like to insert an IP address into a column of my log table!

Any ideas as to where that value might be stored such that SQL Server can retrieve it?

Thanks in advance,
jerry

 

Hi,
Create some code in the default page they hit at first using something like this:
Dim User_IP As String = Me.Context.Request.ServerVariables("REMOTE_ADDR")
Then take that User_IP and cast it as a string value into one of your tables.
Make sense?
All the best,
Mark