AS
-- SPID to MAC
-- lj
DECLARE @MAC as varchar(12)
SELECT @MAC = NET_ADDRESS FROM master..sysprocesses WHERE SPID = @SPID
-- MAC to IP
DECLARE @MACDisplay as varchar(18)
DECLARE @IP as varchar(15)
CREATE TABLE #temp (OUTPUT varchar(255) null)
SET NOCOUNT _disibledevent= \'master..xp_cmdshell \"ping -a \' + @IP + \'\"\'
--exec (@CMD)
DROP TABLE #temp
SET NOCOUNT OFF
GO
2008-12-14 at 13:08