>Hi All,
>
>Newbie Question:
>
>I have a test database that does not not include the triggers that are present in the production database.
>What is the best way to copy all the triggers from the production DB and apply them to the test DB?
>
>TIA,
>
>Andy

Hi Andy,

To get a list of the triggers you can use

-- Give the list of all triggers in the database
SELECT  tablename = object_name(parent_obj), name
FROM    sysobjects
WHERE   type = 'tr'