Audit created and modified by user in temporal table (without trigger) - SQLRelease
This post briefs how we can capture the created by and modified by user names in a temporal table without using a trigger. Microsoft introduced Temporal tables in SQL Server 2016. Temporal tables are system versioned tables that have built-in support for row-level change tracking. We can create a new table as a temporal table or we can convert an existing table into a temporal table. The temporal tables keep the current data into the main table and move the historical data into an associated history table. The history table has the same schema as the main table and we cannot modify the schema of the history table.
https://www.dhirubhai.net/feed/update/urn:li:activity:6800839598361587712