title: how to save a trigger in sql server enterprise manager studio
body: <p>i can right click on a table and go to the <strong>Triggers</strong> 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.  </p>
  
  <p>How to i "commit" this trigger to the table ?</p>
  
  <h2>EDIT:</h2>
  
  <p>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.</p>