October 20, 2011 at 7:20 am
Hi,
Is there a way to find out who made changes to a table using dmvs?
Thanks
October 20, 2011 at 8:03 am
As far as I know, NO. You can check the default trace to see if it is registered there.
The best way would be to set Auditing on the table you are interested in to catch any future changes.
-Roy
October 20, 2011 at 8:08 am
No.
If you need to be able to know who changed data in a table, you either need to have a trace running or set up auditing.
October 20, 2011 at 8:09 am
the other answer is change management tracking. Which means new code is tested, saved and accessible with all the info you need.
October 20, 2011 at 8:21 am
I assumed the OP was referring to data changes.
Of course change management should be used for any DDL/code deployment.
October 20, 2011 at 8:23 am
Steve Cullen (10/20/2011)
I assumed the OP was referring to data changes.Of course change management should be used for any DDL/code deployment.
Could be... but still on the 50 yard line after re-reading.
October 20, 2011 at 11:20 am
Piling on at this point, but nope. Not a chance. the DMO objects store either real time information or aggregation information. They couldn't store historical information without the system databases taking a major portion of your server.
One option open to you not previously mentioned is extended events.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply