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 |
|
Chris_Kelley
Posting Yak Master
114 Posts |
 Posted - 2014-10-24 : 16:49:54
|
| Happy Friday Everyone,lets say a table keeps changing and no one knows how, is there a log that will show what script ran against the db to make the change? like maybe the transaction logs? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-24 : 16:53:40
|
| I would run a trace or add a trigger to capture the activity. No such log exists by default. Yes it's in the transaction log, provided proper recovery model, but good luck deciphering it.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
Chris_Kelley
Posting Yak Master
114 Posts |
Posted - 2014-10-24 : 16:56:02
|
| The problem is the change is random, there is no job, but some proc is running and flipping a bit. Otherwise I run the profiler but I cannot make it happen, I just have to set it up and wait. |
|
|
|
|
|
|
Activity Log??