>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


I use the simpler method of adding default code to the column: GetDate() and mark them as "not null".
Therefore if the date value is not supplied in Update and Insert statements, the table automatically will insert the proper DateTime.