TR_SESSION_UPDATE_DATACHANGED
Definition
Copy
create trigger [dbo].[TR_SESSION_UPDATE_DATACHANGED]
on [dbo].[SESSION]
for update
as begin
set nocount on
--Check that MarkingColumnSet cannot be changed if marking columns are in use
if update(MARKINGCOLUMNSETID)
begin
if (exists (select inserted.MARKINGCOLUMNSETID
from inserted
inner join deleted on inserted.ID = deleted.ID
where inserted.MARKINGCOLUMNSETID <> deleted.MARKINGCOLUMNSETID
and dbo.UFN_SESSION_MARKINGCOLUMNSET_INUSE(inserted.ID) <> 0))
raiserror('BBERR_SESSION_MARKINGCOLUMNSET_INUSE', 13, 1);
end
end