When using a SQL FileTable table, I would like to store additional metadata for the file such as CreatedBy and LastModifiedBy. By looking at [SQL File Table Schema](https://learn.microsoft.com/en-us/sql/relational-databases/blob/filetable-schema?view=sql-server-2017) , this information is not available by default.
I am wondering if it's possible to determine such information by for example adding a trigger to the table and use [current_user](https://learn.microsoft.com/en-us/sql/t-sql/functions/current-user-transact-sql?view=sql-server-2017) to determine current user and store it in a separate table?
I exploring the feasibility of SQL FileTable for a project and have never used this tech.
Asked by Henrique Zacchi
(141 rep)
Aug 15, 2019, 11:51 AM
Last activity: Sep 27, 2019, 10:46 AM
Last activity: Sep 27, 2019, 10:46 AM