sql 2005 update trigger.

Hi all.
I have two table below that I have created.

create table medreason
(
      membid int,
      lastnm varchar(50),
      ident int      
)
create table medreason_bak
(
      membid int,
      lastnm varchar(50),
      medr_ident int,
      change_dt  smalldatetime
      ident_bk  int      
)

I am needing to write a before update trigg? That will take the data from medreason that is being updated and place it into medreason_bak
I am working in sql 2005.
I alsso want it to be able to enter the date and time that the update happened.
Ident_bak will be an identity colun in the medreason_bak table.


Any help would be apreciated.
Start Free Trial