Have you tried binding default constraints to the columns, e.g.
ALTER TABLE [dbo].[branch] ADD CONSTRAINT [df_mod_by] DEFAULT (suser_sname()) FOR [modified_by]
GO
ALTER TABLE [dbo].[branch] ADD CONSTRAINT [df_mod_date] DEFAULT (sysdatetime()) FOR [modified_date]
GO
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”