Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Location
    Iran
    Posts
    4

    Unanswered: IP Address or MacAddress

    Hi
    I want to know that is there a system sp or table or somewhere in sql server that I can get ip address or mac address of clients that connect to sql server?
    thanx

  2. #2
    Join Date
    Feb 2005
    Location
    London
    Posts
    19
    SELECT *
    FROM master.dbo.sysprocesses

    net_address represents MAC Address

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •