use a trigger instead...
/*some_master_table_hist has same structure as some_master_table except for a date field
*/
create trigger tr_delete_example
on some_master_table
after delete
as
begin
insert some_msater_table_hist
select *,getdate()
from deleted
end