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 |
|
ljp099
Yak Posting Veteran
79 Posts |
 Posted - 2011-10-28 : 09:21:42
|
| I have a datetime column on a table that is being updated every morning at 4am with a date value that is a future date. I cannot find or figure out what is causing this update to occur every morning at this time with a future day (36 hours in the future). I don't know how I can monitor/track the updates made to the table. How can I identify what is making this update so I can stop and fix the issue?Thanks |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-10-28 : 11:04:22
|
"Or remove everyones access"I love a good "scream" test  |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-28 : 11:08:51
|
| still if you can find it then add an instead of trigger for update and check if updation time is 4 am and bypass it to do nothing------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-10-28 : 11:35:47
|
| "instead of trigger for update"Or an AFTER trigger with ROLLBACK perhaps? (Less arduous to write, I reckon ) |
|
|
|
|
|
|
Track changes on table column