Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2015-03-19 : 17:12:20
|
| Hi I can right click on the database and do schema change history, I can only get the last modified date of a table.Where is this information stored? I want to restore the master, system to show who modified the data.Is there a way to do this ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-19 : 17:15:06
|
| Unless you are storing the info, it is not being captured.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2015-03-20 : 06:29:00
|
quote:
Originally posted by TRACEYSQL
I want to restore the master, system to show who modified the data.
You could restore successive backups (to a TEMPORARY database) in order to work out WHEN the change occurred. It can be tedious to do ...We log absolutely everything we can think of ... helps when we have a problem and need tow work out what went wrong. Our logging data tables are usually several times bigger than the client's own data ... even though we have daily purge routines and only retain such data for 7 days or so. |
|
|
|
|
|
|
Trigger modification