February 1, 2012 at 1:12 pm
I am trying to write a query to get the following information on columns:
DBName | Tablename |Column name | Last_user_update | User name
I have written this query, but I was able to see only tablename, last_user_updated. I don't see any relation between sysusers and sys.dm_db_index_usage_stats.If you could able to assist in writing this query that would be great. Thank you
February 1, 2012 at 1:21 pm
There isn't any such relationship. SQL does not keep track of who modified what. If you need that info, you need triggers, trace, extended events or SQLAudit.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply