Trigger Compare Overview
A trigger compare checks for differences between the text of two or more triggers within a database. ComparePro searches the triggers for identical lines of text, and reports any differences as inserts, deletes, or moves.
To create a trigger compare
From the File menu, select New > Trigger Compare.
For example,
CREATE TRIGGER dbo.TestTrigger1
CREATE TRIGGER [dbo].[TestTrigger1]
CREATE TRIGGER [dbo].[TestTrigger1]
The two lines above perform the same function. Because the second line includes brackets around the schema and trigger names, ComparePro would report this as a difference. Review the Detailed Results to determine the significance of any differences found. The maximum number of files or tables allowed in a comparison is 100.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*