CREATE PROCEDURE Run_CommandRun_
Pan Shin
@UDN int
AS
--print 'Run_CommandRun'
declare @
Pr Key? varchar(255), @command varchar(255)
declare @mac varchar(255), @macini varchar(16)
select @Pr Key? = (select Pr Key? from TCT_CommandRun where UDN = @UDN)
insert into Synch(UDN,spid, name) values(@UDN, @@SPID, @
Pr Key?)
select @mac = (select hostname from master.dbo.sysprocesses where spid = @@SPID)
/*
select @macini = (select net_address from master.dbo.sysprocesses where spid = @@SPID)
select @mac = substring(@macini,1,2)+'-'+substring(@macini,3,2)
+'-'+substring(@macini,5,2)+'-'+substring(@macini,7,2)
+'-'+substring(@macini,9,2)+'-'+substring(@macini,11,2)
*/
select @command = @
Pr Key?+' '+@mac+' '+convert(char,@UDN)+' '+convert(char,@@SPID)+' '+@
Pr Key?
exec master.dbo.xp_procexec @command
GO
