Solutions Products Downloads Prices Support
ApexSQL DBA
SQL Server management and database administration
  • ApexSQL Audit
  • ApexSQL Backup
  • ApexSQL BI Monitor
  • ApexSQL Defrag
  • ApexSQL Discover
  • ApexSQL Job
  • ApexSQL Log
  • ApexSQL Manage
  • ApexSQL Monitor
  • ApexSQL Plan
  • ApexSQL Propagate
  • ApexSQL Recover
  • ApexSQL VM Monitor
ApexSQL Developer Database development and continuous integration
  • ApexSQL Analyze
  • ApexSQL Build
  • ApexSQL CI/CD toolkit
  • ApexSQL Compare
  • ApexSQL Complete
  • ApexSQL Data Diff
  • ApexSQL Decrypt
  • ApexSQL Diff
  • ApexSQL Doc
  • ApexSQL Enforce
  • ApexSQL Generate
  • ApexSQL Mask
  • ApexSQL Model
  • ApexSQL Pump
  • ApexSQL Refactor
  • ApexSQL Script
  • ApexSQL Search
  • ApexSQL Source Control
  • ApexSQL Trigger
  • ApexSQL Unit Test
What's new What's next

Database administration

  • Auditing and compliance
  • Database backup
  • Database management
  • Disaster recovery
  • Forensic auditing
  • Index defragmentation
  • Multi-DB script execution
  • Performance monitoring
  • Query optimization
  • Server compare
  • SQL job automation
  • SSAS monitoring
  • SSIS monitoring
  • SSRS monitoring
  • Transaction log reading
  • Virtualization monitoring

Database development

  • Continuous delivery
  • Continuous integration
  • Custom application auditing
  • Data compare
  • Data import/export
  • Database documentation
  • Database modeling
  • Dependency analysis
  • Developer productivity
  • Development best practices
  • Documentation
  • Object decryption
  • Object refactoring
  • Packaging and deployment
  • Schema and data scripting
  • Schema compare
  • Script comparison
  • SharePoint documentation
  • SQL formatting
  • SQL Server documentation
  • SQL source control
  • SQL unit testing
  • SSAS documenation
  • SSIS documenation
  • SSIS package compare
  • SSRS documenation
  • Statement auto complete
  • Static code analysis
  • Test data generation
  • Text and object search
Solution center
Knowledgebase

ApexSQL Trigger knowledgebase – Table of contents

Permissions and requirements

  • Minimal SQL Server permissions for ApexSQL Developer tools
  • Minimum requirements for installing ApexSQL Trigger
  • Supported software for ApexSQL Trigger
  • ApexSQL Trigger and ApexSQL Trigger Viewer – Permissions and requirements

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


 

By topic

General

Sales

By product

ApexSQL Analyze

ApexSQL Audit

ApexSQL Backup

ApexSQL BI Monitor

ApexSQL Build

ApexSQL CI/CD

ApexSQL Compare

ApexSQL Complete

ApexSQL Data Diff

ApexSQL Decrypt

ApexSQL Defrag

ApexSQL Diff

ApexSQL Doc

ApexSQL Enforce

ApexSQL Generate

ApexSQL Log

ApexSQL Model

ApexSQL Monitor

ApexSQL Recover

ApexSQL Refactor

ApexSQL Script

ApexSQL Search

ApexSQL Source Control

ApexSQL Trigger

ApexSQL Unit Test

ApexSQL VM Monitor

Popular

  • How to configure remote access and connect to a remote SQL Server instance with ApexSQL tools
  • Rules of SQL formatting – Nesting and indenting SQL statements
  • How to activate ApexSQL software manually
  • Tips and tricks for using ApexSQL Refactor SQL formatting options – General options, Capitalization and Comments
  • How to link a SQL Server database to a source control system
  • How to get the hardware ID
  • How to install ApexSQL add-ins and integrate into host environments e.g. SSMS, Visual Studio
  • How to execute large SQL scripts
  • ApexSQL Audit – Permissions and requirements
  • Installing ApexSQL Audit
  • SQL snippets
  • ApexSQL Search – Text search
  • ApexSQL Search – Introduction
  • How to create and maintain a full chain of transaction log backups
  • How to synchronize data between databases with different settings
  • Tips and tricks for using ApexSQL Refactor SQL formatting options – Parameters, Columns, Joins, and Flow control
  • ApexSQL Diff Command Line Interface (CLI) switches
  • Installing ApexSQL monitoring tools
  • ApexSQL Monitor – Permissions and requirements
  • Code completion

Software

What's supported

Requirements

Testimonials

Sales

Support plans

Renewals and upgrades

Licensing

Help

Technical support

Customer service

Resend keys

News

What's new

What's next

Blog

Free stuff

Tools

Editions

Licenses

Company

Contact

About

Community

Gold Partner

© 2018 ApexSQL LLC   |   +1 (866) 665-5500   |   sales@apexsql.com   |   support@apexsql.com