Hello all, first things first - I have never used triggers. In a lot of my sp's I create a record of the current values of a table that I'm about to update along with the new values for the table - this makes it very easy for me to report on edits, is it possible to do this using a trigger ? A typical example of what I do is shown below

Proc UpdateAddress(@Addressid int,@line1 varchar(35),(@line2 varchar(35),
(@line3varchar(35),
(@line4 varchar(35))
As
Insert into AddressHistory
(Addressid int,
line1 ,
line2,
line3,
line4,
xline1,
xline2,
xline3,
xline4)
(Select
Addressid,
line1,
line2,
line3,
line4,
@line1,
@line2,
@line3,
@line4 from address where addressid = @Addressid  )

-- Then update the address table with new values