Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

database realted Expand / Collapse
Posted Wednesday, February 6, 2013 4:10 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, February 9, 2013 6:00 AM
Points: 27, Visits: 65
is there any way i can find out , from which machine changes been done on particular database ( suppose databasename abc)
Post #1416396
Posted Wednesday, February 6, 2013 4:14 AM



Group: General Forum Members
Last Login: Thursday, September 1, 2016 2:56 AM
Points: 5,969, Visits: 6,067
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

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1416402
Posted Wednesday, February 6, 2013 5:12 AM



Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 17,173, Visits: 32,141
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
The Scary DBA
Author of:
SQL Server Query Performance Tuning
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1416423
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse