General information
Forum:
Microsoft SQL Server
Title:
How to update datetime field automatically
Environment versions
SQL Server:
SQL Server 2000
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only