TR_SPROPPNOTETYPECODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_SPROPPNOTETYPECODE_INSERT_BBNCCODETABLEIDMAP on dbo.SPROPPNOTETYPECODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '4ca73726-4511-496b-8a2b-fa44999832f2', ID from inserted end