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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Table altered JOb

Author  Topic 

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2011-03-07 : 01:20:52
Dear All,

Seems our production DB one particular table "Datemodified" column has been updated by some job on 2 weeks back.not very sure which job altered this job.

Can we identify this which job makes this "datemodified" field get updated ?


Thanks,
Gangadhara MS
SQL Developer and DBA

sql_server_dba
Posting Yak Master

167 Posts

Posted - 2011-03-08 : 13:19:54
check whether the table has any triggers on it.
Go to Top of Page
   

- Advertisement -