I have a database which has many table with 'updatedon' field of datetime type. These are updated on the client side. I want then to be updated on the server through triggers. And possibly with only one procedure called by all the table.

1> How can I dynamically find out the table contains updatedon field and its type.
2> Is there any globally called trigger called by every table in the database which will update the field.


Rajesh