If modifications to other tables are based on changes to the original table, than you should use triggers. Otherwise modifications to data in the original table that is done ouside of srored procedures will breake data integrity.
>Thank you for reply.
>What if I want to update other tables upon insert/update/delete record on particular table? Should I use trigger or write my CRUD in SP and include logic to update other table in that SP?
--sb--