I would like to apply same check constraint to 5 columns in the same table. Can I use just one check constraint? How do I write a script...

Thanks Kevin.

Thanks Alan.

Thanks Kevin!

Ok thanks.

Thanks Grant!

Thanks Hugo.

The vendor does not want to track all the history of audit columns. They want to keep the audit information(last insert/update) on the same table. Also want to make...

Thanks a lot Hugo.

Did you already try the approach with column-level permissions? Have you considered the (IMO much better) alternative to have a separate audit table?

Not able to apply...

Could you please help me to create a single trigger for both inserts and updates in this case.

Many thanks!

Thanks Hugo!

Thanks Lynn!

Thanks Hugo.

Can I add deny update on the audit create columns in the existing UPDATE trigger.

I cant do any inserts with the INSERT trigger in place and the UPDATE trigger...

Thanks. Here's the DDL. I would also like to deny future updates on the [CreateDate] and [CreateUser] fields. How is it possible.

/****** Object: Table [dbo].[Test1] Script...

When I have an insert and update trigger on the same table, the Insert trigger is triggering the Update trigger to execute since I use UPDATE statement in the INSERT...

Users are still able to insert an invalid date/user in the Audit columns with default constraints. What is the best way to avoid this.

Thanks!