>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
SELECT tablename = object_name(parent_obj), name
FROM sysobjects
WHERE type = 'tr'
If it's not broken, fix it until it is.
My Blog