hi i have a trigger deployed in production. now they have added new columns to the table. is there a way i can write small script which would alter the trigger and insert the column fields at appropiate fields. will simple alter triggername add column to area, column 2 to area2, column3 to area3 work thanks justin

Hi Justin, Post your link here, that is the correct place for your question:- http://social.msdn.microsoft.com/Forums/en/transactsql/threads Thanks KumarKG, MCTS

did that thanks but can u answer me on how to proceed