Gets the IP address of the client on which the process is located, based on the process number

IP Address | process | Client CREATE PROCEDURE dbo. Sp_spidtoip @SPID int AS--SPID to MAC--LJ DECLARE @MAC as varchar (a) SELECT @MAC = net_address from master. sysprocesses WHERE SPID = @SPID-MAC to IP DECLARE @MACDisplay as varchar (a) DECLARE @IP as varchar CREATE TABLE #t EMP (OUTPUT varchar (255) NULL) SET NOCOUNT on INSERT into #temp EXEC master. xp_cmdshell ' arp-a ' if @ @error begin RAISERROR (' The level for job_id:%d should is between%d and%d. ', 1)--rollback TRANSACTION end SELECT @MACDisplay = Left (@MAC, 2) + '-' + SUBSTRING (@MAC, 3, 2) + '-' + SUBSTRING (@MAC, 5, 2) + '-' + SU Bstring (@MAC, 7, 2) + '-' + SUBSTRING (@MAC, 9, 2) + '-' + SUBSTRING (@MAC, one, 2) SELECT @IP = SUBSTRING (output, 3,) from #temp WHERE output like '% ' + @MACDisplay + '% '--Resolve the IP--declare @CMD as varchar (MB)--select @CMD = ' master. . xp_cmdshell "Ping-a ' + @IP + '" '--exec (@CMD) DROP TABLE #temp SET NOCOUNT off go