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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Activity Log??

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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.

Go to Top of Page
   

- Advertisement -