how to save a trigger in sql server enterprise manager studio

Question

i can right click on a table and go to the Triggers folder and click "New Trigger". I can then fill out the SQL for the trigger but when i click save, it just wants to save it to a ".sql" file.

How to i "commit" this trigger to the table ?

EDIT:

as per my comment below, i did hit execute but it wasn't showing up in the "Triggers" folder. It looks like you have to click "Refresh" for it to show up.

Answer 1

Hit Execute or F5

Answer 2

You just run the trigger, it should start with CREATE TRIGGER, so just hit execute