Logging IP Address ?

• cameronbraidwood

  SSC-Addicted

  Points: 460

  More actions

  January 25, 2003 at 1:55 am

  #80624

  Is there any way to log IP address from incomming connections / connection attempts within the SQL2K log files ?

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  January 25, 2003 at 5:23 am

  #447221

  Only way I know is to run a trace that captures it. Or you can just do it by convention, run a proc that records the IP when they login.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter