>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
>
>
>
>

Sure, although you can also do the same using OUTPUT clause of Update command in your SP that updates the Address table. Triggers should be used as a last resort.