DBMS_SESSION.set_client_identifier equivalent in SQL Server

Question

Hi,

I am new to SQL Server and I am more familiar with ORACLE database. I'd like to know if there's a way to set client identifier context like in Oracle by using DBMS_SESSION.set_client_identifier and grab the value using a function.

I am trying to track data changes including who/which username made the changes. My plan to create Triggers that capture the OLD value, NEW value, and the username.

The connection to the server is using pooled connection, so using the username that connects to the DB is not the answer.

anyone has an idea?

Thanks before, -Y