• wat3575,

    When you're in SSMS, click View --> Template Explorer. Go to the Triggers section to see 4 different example templates for building a new trigger.

    Lots of good education in the Templates Explorer, enough to get you started to where you can ask a more specific question.

    Also, check Help. Click the search tab and enter 'CREATE TRIGGER'

    Hth,

    Sigerson

    "No pressure, no diamonds." - Thomas Carlyle