Identify the machine name and IP address

• hhp

  Right there with Babe

  Points: 756

  More actions

  January 22, 2003 at 7:28 pm

  #64761

  Is there a way to identify the machine name and IP address of someone in SQL Server? I want to write a trigger that capture

  who (machine name and IP) deleted a record. I also want to pass the machine

  name and IP address from to a stored procedure.

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  January 22, 2003 at 7:55 pm

  #447028

  Select Net_Address,NT_Username,Hostname

  From master..SysProcesses

  Where Spid=@@Spid