for anyone whos interested...

declare @cmd_t table (id int not null identity(1,1) primary key, cmd nvarchar(200))

declare @wait_time int

set @wait_time=60000

insert into @cmd_t(cmd)

select distinct 'kill '+convert(nvarchar,spid) from sysprocesses where spid in (

select blocked...

i already know what is locking

sorry my question was asked very badly!

really what i want is something that will show me what tables are updated in our live ERP system if for example...

yea i want to track changes in data - tho if possible as cheaply as possible!!:hehe: