SELECT DISTINCT
MacAddress = net_address
FROM master..sysprocesses
WHERE hostname = LEFT(@@servername, CHARINDEX('\ ', @@servername + '\ ') - 1)
MacAddress = net_address
FROM master..sysprocesses
WHERE hostname = LEFT(@@servername, CHARINDEX('\ ', @@servername + '\ ') - 1)