I have a table t with a datetime field dbupddate. That field should reflect the last time the record was inserted/updated.
I have already made a default constraint to set it to getdate(), but that doesn't prevent a user to insert a non-default value.
I also do not have the authority to create a trigger or modify an existing one.
Is there a way to enforce the correct value of getdate() to be inserted/updated?
From the comments, I deduce the short answer is no, and I received many useful suggestions. Thank you all.