Timeline for How to detect any changes to a database (DDL and DML)
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Jun 28, 2018 at 9:27 | history | suggested | WAF | CC BY-SA 4.0 |
Readability
|
| Jun 28, 2018 at 7:59 | review | Suggested edits | |||
| S Jun 28, 2018 at 9:27 | |||||
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot |
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
|
|
| Jul 27, 2015 at 11:01 | answer | added | Anvesh | timeline score: 0 | |
| Jun 23, 2014 at 19:21 | answer | added | Ivan Stankovic | timeline score: 1 | |
| Dec 26, 2011 at 7:37 | answer | added | Anil Inampudi | timeline score: 1 | |
| Feb 1, 2011 at 18:46 | comment | added | garik | @jcolebrand yes, I did. I my case I have to check any database activity and then to make backup (full or differential). I am checking LSN (the primary key of log record), that function fn_dblog returns. That is all. I don't think that it will work in your case. I have not investigated all features of data that can be returned by fn_dblog, but I think it does not return all information to do with. As you can see there are many other system tables joined to it. If it was easy we would have a lot of normal, cheap tools :) | |
| Feb 1, 2011 at 16:39 | comment | added | jcolebrand♦ | So did you implement this as part of a job or??? I'ld love to have a method of daily outputting (say at 2am) all changes from the previous 24 hours to a directory so I can have a bit of a changelog for myself. | |
| Jan 31, 2011 at 16:38 | vote | accept | garik | ||
| Jan 31, 2011 at 16:37 | history | edited | garik | CC BY-SA 2.5 |
added 803 characters in body
|
| Jan 30, 2011 at 9:56 | answer | added | Nomad | timeline score: 1 | |
| Jan 30, 2011 at 9:27 | answer | added | Marian | timeline score: 7 | |
| Jan 30, 2011 at 2:16 | history | tweeted | twitter.com/#!/StackDBAs/status/31536117333360641 | ||
| Jan 30, 2011 at 0:21 | history | asked | garik | CC BY-SA 2.5 |