How do i generate the script for a trigger?

I am using SQL Server 2008.

I have created a database which has a trigger on one of the tables.  When i generate the script for creating the whole database I don't get any TSQL for creating the trigger.

Am i doing something wrong?
Who is Participating?

Improve company productivity with a Business Account.Sign Up

pivarConnect With a Mentor Commented:

In Tools/Options/SQL Server Object Explorer/Scripting, is Script triggers set to true?

soozhAuthor Commented:
that was it!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.