I have table which can be updated by user who login from SSMS or a .net application can update data in table.
A .net application can execute in-line query from there to update table or a .net application can call a store procedure to update data in table. how do i find out who update data in table just by running any script.
please tell me few ways to extract this info from database who update a particular table.
1) if a user update table from SSMS then i need user login name
2) if any .Net application update data in table then i should get .net application name.
Please share the script or any other way to extract this info from database who update a particular table.
thanks
Edit
Some links i got after searching google
https://www.sqlshack.com/track-history-data-changes-using-sql-server-2016-system-versioned-temporal-tables/
https://stackoverflow.com/questions/29834515/how-to-find-who-last-modified-the-table-in-sql-server
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/160680a3-3f9f-43b1-a689-91943461dda7/how-to-find-which-loginuser-has-modified-the-record-in-a-table-in-sql-server-2008?forum=transactsql