Permissions and requirements
- Minimum requirements for installing ApexSQL Trigger
- Supported software for ApexSQL Trigger
- Minimum permissions required to install and use ApexSQL products
- ApexSQL Trigger and ApexSQL Trigger Viewer – Permissions and requirements
Configuration and setup
- Silent installation and un-installation of the ApexSQL products
- How to configure remote access and connect to a remote SQL Server instance with ApexSQL tools
- How to turn off the ApexSQL auto-updater
- How can I tell if I have the latest version of my ApexSQL software
Licensing and activation
Auditing
- How do I choose between ApexSQL Trigger and ApexSQL Log?
- How to create an auditing plan
- Installing audit tables on another database
- How do I delete old data from audit tables?
- How to update ApexSQL Trigger without losing custom changes in the architecture
- How do I audit only some users in ApexSQL Trigger?
- How to audit usernames in ASP.Net application
- How to create an auditing profile to track “users” in a custom system using a single SQL Server login
Reporting
- How to send email alerts when a change is made to a database record
- Auditing reports in ApexSQL Trigger
- How to customize an auditing report
- Schedule ApexSQL Trigger report generation
Features
- How to track DDL/schema changes
- How to manage triggers in ApexSQL Trigger
- How to use the Watches feature in ApexSQL Trigger
- How to use the Lookup feature in ApexSQL Trigger
- Using the template editor in ApexSQL Trigger
Command line interface
- ApexSQL Trigger Command Line Interface (CLI) switches
- General usage and the common Command Line Interface (CLI) switches for ApexSQL tools
- How to use an argument file in the CLI
- How to use a project file in the CLI
Scheduling and automation
- Four ways of handling database/login credentials during automated execution via the CLI
- How to automate and schedule CLI execution with SQL Server Job
- How to automate and schedule CLI execution with Task Scheduler
- How to create a login form dialog using PowerShell, accept user input and pass it to an ApexSQL console application
- How to email the output of a scheduled CLI job
- How to setup an e-mail alert system for ApexSQL tools
