| Author |
Topic |
|
kumarich1
Yak Posting Veteran
99 Posts |
 Posted - 2008-02-13 : 14:46:37
|
| How to find a last activity happened on a table? |
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2008-02-13 : 15:12:51
|
| There is no enough information...hey |
 |
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2008-02-13 : 15:18:11
|
| I am trying to find out who performed last activity on a table like update, delete or insert.Thanks in advance |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-13 : 15:49:08
|
| Track with the Trigger. |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2008-02-13 : 16:19:03
|
quote:
Track with the Trigger.
As a DBA, do you guys put a trigger on every single table to track this? What your opinion anyway? |
|
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2008-02-13 : 17:10:06
|
| Can any body please let me know how I can find last activity occured on a table. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-13 : 17:36:04
|
| Try thisselect name,create_date,modify_date from sys.tablesWHERE create_date <> modify_dateORDER BY modify_Date |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2008-02-13 : 20:03:59
|
quote:
Originally posted by sodeep
Try thisselect name,create_date,modify_date from sys.tablesWHERE create_date <> modify_dateORDER BY modify_Date
This thing is only for finding out the structure of that table is changed I think not the records. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-16 : 00:07:27
|
| Use sql auditing tool. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-16 : 02:17:39
|
| Use a trigger to put information on action performed and infomation of user who performed action onto a table. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-16 : 14:33:23
|
| That costs too much. |
|
|
|
|
Last activity on a table