February 6, 2013 at 4:10 am
is there any way i can find out , from which machine changes been done on particular database ( suppose databasename abc)
February 6, 2013 at 4:14 am
could check the default trace, depending on how active the server is
other than that if you dont do custom auditing your out of luck
February 6, 2013 at 5:12 am
If you're talking data changes there's no automatic auditing within SQL Server by default. You can look to extended events as a mechanism to see all data changes by capturing sql batch and rpc completion. This works without modifying the database. If you can/want to modify the database then you can use change data capture.
"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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply