CODEWITHSUNDEEP
sql-servertriggers
Álvaro García
Álvaro García

Reputation: 19386

how to save changes in an existing trigger?

I have a trriger in a table, but I need to add a new line of code, and when I click the save button, I am prompted to save a .sql file,I save it but the changes are not saved in the trigger.

I am using SQL Server 2014 express.

So I would like to know how can I save the changes in my existing trigger.

Thanks so much.

Upvotes: 2

Views: 1665

Answers (1)

HaveNoDisplayName
HaveNoDisplayName

Reputation: 8497

After you made your changes in Trigger, you then have to Press F5. Then the Trigger code compiles. If SQL Compiled it successfully it will be saved, otherwise it throw error message to you.

So next time when you open trigger again, you are able to see your updated Trigger code.

Upvotes: 4

Related Questions