Does anyone know of a way to tell when a particular row in
a table was last changed. We're doing some trouble
shooting and the info would sure come in handy.
Thanks,
jrJim,
There's no built in way to do this. You need to create triggers on your tabl
e or
you will have to build this
functionality into your application. For instance, you can have a column on
the
table UPDDATE and within the
application/trigger you will update this column with getdate() whenever you
fire
an update statement.
Refer to following url.
Audit insert/udpate/delete with triggers
http://www.devx.com/dbzone/Article/7939/0/page/1
- Vishalsql
订阅:
博文评论 (Atom)
没有评论:
发表评论