Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Server Trigger - Need to Alter

I need to alter a trigger in SQL Server. After I am doing, do I just execute the trigger similar to how I would do for a Stored Procedure?

    ALTER TRIGGER 
like image 570
Nate Pet Avatar asked Dec 22 '11 16:12

Nate Pet


1 Answers

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

like image 86
D'Arcy Rittich Avatar answered Nov 15 '22 09:11

D'Arcy Rittich