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
