what abt this..

One single encrypted procedure containing the open master key statement.

In the procedure that inserts the data

call the master key proc

do the encryption & insertion

insertion will call the trigger. keep the trigger if required.

close the master key.

again these are things that i have not tried out...

all the best and keep us posted.