No no i don't want to add column because third party software create new db /tables/view etc. I have more than 30-35 db and each db has more than 2-3 hunders tables and views. So just i have to track in which db has insert/edit/delete record....can we get thoes information from system database or system tables?
Short of adding a column or running a Profile trace, I can't think of any way to get the time a row was last modified. Operative word being MIGHT, you might be able to work something out using replication to another database and establishing a "heartbeat" if you were really looking for something to help occupy your spare hours for the lifetime of this application.