• You have to be more specific. What don't you know how to do? How to send a parameter to the procedure? How to write a trigger for insert? How to get the values that were inserted to the table in the trigger?

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/