A very simple question, but supposedly a difficult answer.
- How do you retrieve a MAC address using SQL?
We need it for a redundancy system involving several SQL Servers and need to know which computer last updated the main DB. The Computer Name isn't good enough since a couple of machines actually have the same name (they are not operated simultaneously, one is cold standby.)
One complicating factor is the presence of two NICs. They are named LAN and PLC, respectively.
A quick solution would be greatly appreciated.