The CopyAllTriggers property controls the transfer of Microsoft® SQL Server™ triggers from the source to the target database.
object.CopyAllTriggers [= value]
object
Expression that evaluates to an object in the Applies To list
value
TRUE or FALSE
Boolean
Read/write
HRESULT GetCopyAllTriggers(LPBOOL pRetVal);
HRESULT SetCopyAllTriggers(BOOL NewValue);
If TRUE, all SQL Server triggers in the source database are copied to the target.
If FALSE, only triggers indicated by the AddObject and AddObjectByName methods are copied.