I am trying to add System versioning to my tables. However, I would like to log who has done the change. The user is send to me with the SESSION_CONTEXT. I hoped to fix this, by adding a persisted computed column, which saves the column, however this is a non determistic function. So I cannot use that idea.
Are there any way's to add a SESSION_CONTEXT to a column in my table? (I would like to avoid a trigger). Or is there a way to store who did the change (based on the SESSION_CONTEXT) in my history table?