title: Get SQL UserName that modified a table in Sql Server
body: <p>How can I get the sql username that modified a table? I have this query but I didn't find this info, it is probably another table?</p>
  
  <pre><code>SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update,*
  FROM sys.dm_db_index_usage_stats
  WHERE database_id = DB_ID( 'MyDb')
  AND OBJECT_ID=OBJECT_ID('dbo.mytable')
  </code></pre>