SQL Server Trigger - Change Required

Question

I need to change a trigger in SQL Server. After I do this, I just start the trigger, similar to how I will do for the stored procedure?

ALTER TRIGGER 

Answer 1

Yes, that's right, just use ALTER . If you right-click a trigger in the Object Explorer in SSMS and select Script Trigger as / ALTER TO, you will see the ALTER statement created for your trigger.

Answer 2

 ALTER TRIGGER triggerName ON tableName FOR INSERT -- or update & delete AS -- sql here 

http://msdn.microsoft.com/en-us/library/ms176072.aspx

Answer 3

You are not executing a trigger. Triggers “fire” at specific points depending on your definition.

For example, an AFTER UPDATE trigger fires for all updated rows after sending the UPDATE command to the table in which the trigger is created.