• certainly , we can have trigger (instead of) but i will suggest to set the trigger on table.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)