Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

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?
0
soozh
Asked:
soozh
1 Solution
 
pivarCommented:
Hi,

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

/peter
0
 
soozhAuthor Commented:
that was it!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now