update proc_packs
set station=109 
where id=3456789

exec sp_lock

create table #sp_lock_results
(
	spid smallint,
	dbid smallint,
	ObjId int,
	IndId smallint,
	Type nchar(4),
	Resource nchar(32),
	Mode nvarchar(8),
	Status nvarchar(5)
)

insert into #sp_lock_results exec sp_lock

select
	spid,
	dbid,
	db_name(dbid),
	ObjId,
	object_name(ObjId),
	IndId,
	Type,
	Resource,
	Mode,
	Status
from 
	#sp_lock_results
where 	
	object_name(ObjId) = 'proc_packs' 	
order by spid
drop table #sp_lock_results

select o.text, p.* from sys.sysprocesses p
outer apply sys.dm_exec_sql_text(p.sql_handle) o
where p.blocked>0 or p.spid in
	(
	select blocked from sys.sysprocesses
	where blocked > 0
	)

alter index all on proc_packs

ALTER TRIGGER Consume ON dbo.[proc_packs] AFTER UPDATE AS
  SET NOCOUNT ON

  UPDATE proc_packs
  SET
    cday = (SELECT po
            FROM
              proc_prunits pp
            WHERE
              pp.prunit = 52)

  FROM
    proc_packs ppp
    JOIN deleted d
      ON ppp.id = d.id
  WHERE
    ppp.rtype = 12 AND
    ppp.station = 109