One of the great features of ApexSQL Audit is the ability to customize Trigger Code Patterns. Furthermore, you are provided with a professional editor/IDE with syntax highlighting, IntelliSense, line numbering, parsing and debugging, to name just a few features.
Trigger templates employ the exact same paradigm as Active Server Pages, the popular dynamic web authoring technology from Microsoft, as well as the same scripting languages - Microsoft VBScript and JScript. In fact the same script parser and debugger processes both ApexSQL Audit templates and ASP.
So if you are at all familiar with either of these popular scripting languages you can quickly master the art of trigger template customization and creation. Even if you are not - VBScript is easy to learn and ApexSQL Audit will guide you with an existing, fully functional template and IntelliSense, which displays the selections you can choose from as you walk through the ApexSQL Audit Object Hierarchy.
To open up the Trigger Template module - choose "Template Editor" from the Outlook Bar ...
or click the template button
on the toolbar
.
The Template Editor will load the template from the current Audit Architecture Profile that you have selected. You will see the template script itself in the main pane in the template node and to the right a property page for this template.
See Also:
For more information about the Template Editor click here.
|
You have 3 main toggle options with the template editor:
Line Numbers
- this will display line numbers to the left of the code window.
Left Margin
- this will display a space to the left of the script which will allow
the editor to indicate the locations of text that match a Find Request
>> Mark All:
Property
Page - this will hide or show the Property page:
Copyright © 2008 ApexSQL LLC. All Rights Reserved.
