根據進程號獲取該進程所在客戶耑的ip地址

create procedure dbo . sp _ spid toip @ spid int
as
-spid to MAC
-LJ
declare @ MAC as varchar(12)
select @ MAC = net _ address from master..sysprocesses其中spid = @ spid
-MAC to IP
declare @ MAC display as varchar(18)
declare @ IP as varchar(15)
create table # temp(output varchar(255)null)
set no count on
insert into # temp exec master..XP _ cmdshell ' ARP-a '
if @ @ error 0
begin
raiserror(' job _ id:%d的級別應介於%d和% d . '，16，1)
-roll back transaction
end
select @ MAC display = left(@ MAC，2) ' substring(@ MAC，3，2) ' substring(@ MAC，5，2) '-' ..XP _ cmdshell" ping-a ' @ IP '" '
-exec(@ cmd)
drop table # temp
set no count off
go

位律師廻複