Hi,
This will be achieved by creating an after trigger on this table and checking this column value.
I have 10 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET.
Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenance jobs, Optimizing etc.
I have expertise in writing complex queries with proper joins and index selection. Involved in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views.
Thanks