InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 02:54:12 GMT20http://www.sqlservercentral.com/Forums/Topic1412751-391-1.aspxWhat you need is a TRIGGER:http://msdn.microsoft.com/en-us/library/ms189799(v=sql.105).aspxIf you post your table schema, I will put together a sample trigger for you.MattTue, 29 Jan 2013 00:57:23 GMTStupeohttp://www.sqlservercentral.com/Forums/Topic1412751-391-1.aspxHi,I was updated my table ,then i want change status_flg in updated tableis it possiable ?help me ,,RegardsArjunMon, 28 Jan 2013 22:14:08 GMTArjun123