Sample Header Ad - 728x90

MS SQL FileTable CreatedBy and LastModifiedBy

3 votes
1 answer
512 views
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