Category
Topic
Subtopic
ApexSQL Trigger and ApexSQL Trigger Viewer – Permissions and requirements (4216254)
ApexSQL Trigger and ApexSQL Trigger Viewer – Permissions and requirements <p><b>Applies to </b> ... <a href="https://www.apexsql.com/sql_tools_trigger.aspx" target="_blank">ApexSQL Trigger</a> and ApexSQL Trigger Viewer</p>
How do I delete old data from audit tables? (4218130)
How do I delete old data from audit tables? ... Why to delete audited data? ... ApexSQL Trigger uses three tables to store the audited data: AUDIT_LOG_DATA, AUDIT_LOG_DDL and AUDIT_LOG_TRANSACTIONS.
Using the template editor in ApexSQL Trigger (4304605)
An important feature of ApexSQL Trigger, for advanced users, is its ability to customize trigger code patterns. ... ApexSQL Trigger provides a professional editor/IDE with syntax highlighting, auto-complete, line numbering, parsing and debugging features for this purpose
How to track DDL/schema changes (4298937)
What is DDL/schema change auditing and how does it work? ... DDL/schema change auditing is implemented using a DDL trigger ... A DDL trigger, like a DML trigger, executes SQL in response to an event.
INSERT permission denied on object 'AUDIT_LOG_TRANSACTIONS' error is shown (4214909)
Summary ... Triggers were successfully created on the tables, but upon populating the tables with data the following errors are seen: ... “INSERT permission denied on object 'AUDIT_LOG_TRANSACTIONS', database 'My_Database', owner 'dbo'.”
How to send email alerts when a change is made to a database record (4290027)
</li><li><p>Copy the existing architecture from the following location:</p></li><p> <em>C:\Users\<user>\AppData\</em><em>Local\ApexSQL\ApexSQLTrigger2015</em> ... and paste it on the same location or Desktop for example.
How to manage triggers in ApexSQL Trigger (4214923)
If you don’t want to audit all three operation types, deselect its check box before you create the trigger ... To modify the existing triggers for a specific table, use the Manage option in the menu:
Auditing reports in ApexSQL Trigger (4211308)
One of the key features of ApexSQL Trigger is creating auditing reports. ... This feature can be used to create detailed reports containing all changes made to audited objects. ... ApexSQL Trigger has three report types, Standard, Aggregate and DDL.
How do I choose between ApexSQL Trigger and ApexSQL Log? (4216289)
There are certain advantages to using one over the other. ... ApexSQL Trigger is the trigger-based auditing tool. ... There are certain advantages to using one over the other. ... ApexSQL Trigger is the trigger-based auditing tool.
How to setup an e-mail alert system for ApexSQL tools (4214934)
Summary This article describes how to create e-mail alert system for ApexSQL tools using PowerShell in order to send e-mails upon executed ApexSQL tool providing the necessary information. ... Summary This article describes how to create e-mail alert system for ApexSQL tools using PowerShell in order to send e-mails upon executed ApexSQL tool providing the necessary information.
Four ways of handling database/login credentials during automated execution via the CLI (4292458)
Summary ... This article explains how to automate the execution of ApexSQL tools via the CLI while handling the passing of database credentials or using Windows authentication. ... Applies to ... Summary
Minimal SQL Server permissions for ApexSQL Developer tools (4216304)
Description ... In order to properly use ApexSQL Developer tools certain minimal SQL Server permissions need to be allowed on databases that are being used. ... Required permissions ... Required permissions are public SQL Server role and the public role membership that need to be configured along with the login.
Save project as automation script (4213614)
Most ApexSQL tools have a CLI switch to consume a project file. ... This allows for the simplicity and ease of using a project file but also for unattended automation of a batch file or a PowerShell script.
How to add self data change auditing capabilities to commercial, shrink-wrapped software with a SQL Server backend (4213395)
There are thousands of distributed. ... commercial software applications aka shrink-wrapped, from small shareware apps to large corporations, that use a SQL Server backend. ... These systems, although distributed, could often benefit from and sometimes require data change auditing at the client location.
How to create and use DML triggers to audit data changes (4294870)
A DML trigger is a special kind of procedural code programmed to fire when a data manipulation language (DML) event occurs in the database server. ... DML events include UPDATE, INSERT, or DELETE statements issued against a table or view.
How to create and use DML triggers in SQL Server using real world examples (4291390)
Although often maligned, in certain circumstances they can be very helpful... once you get to know them. ... For example, sending an email from SQL Server could be done with a trigger based on some anticipated event.
Audit SQL databases using a SQL Server trigger tool (4262402)
In this article, we will show how to use the ApexSQL Trigger 3 rd party tool to audit your SQL Server Database DML and DDL changes, by creating SQL Server Triggers on the audited tables. ... In this rapidly changing IT world, auditing the SQL Server database becomes a vital task of each database related project, to make sure that the data is stored and maintained securely.
Send logs feature in ApexSQL tools (4288785)
In this article, it will be explained how to use the Send logs feature for sending application log files through ApexSQL tools to the support team. ... Every ApexSQL tool collects all important information regarding work processes and stores them in the log files.
When using ApexSQL Trigger on a virtual workstation, every time the machine is restarted, the application reverts to trial mode. (4238473)
When using ApexSQL Trigger on a virtual workstation, every time the machine is restarted, the application reverts to trial mode. ... This is because there is a new hardware ID every time it's restarted, and the key is no longer recognised against the license server.
Is my ApexSQL application version vulnerable to Log4j - CVE-2021-44228? (4309395)
Determine if the installed ApexSQL application version is vulnerable to <a href="https://nvd.nist.gov/vuln/detail/CVE-2021-44228" target="_blank">Log4j - CVE-2021-44228</a>. The discovery of critical vulnerability <a href="https://nvd.nist.gov/vuln/detail/CVE-2021-44228" target="_blank">CVE-2021-44228</a> in the Apache Log4j library (CVSS severity level 10 out of 10). <p><strong>Unaffected products:</strong></p><p>ApexSQL Analyze<br>ApexSQL Audit<br>ApexSQL Backup<br>ApexSQL Build<br>ApexSQL Compare<br>ApexSQL Complete<br>ApexSQL Data Diff<br>ApexSQL Data Diff for MySQL<br>ApexSQL Database Power Tools for VS Code<br>ApexSQL Decrypt<br>ApexSQL Defrag<br>ApexSQL DevOps Toolkit<br>ApexSQL Diff<br>ApexSQL Diff for MySQL<br>ApexSQL Discover<br>ApexSQL Doc<br>ApexSQL Doc for MySQL<br>ApexSQL Enforce<br>ApexSQL Generate<br>ApexSQL Job<br>ApexSQL Log<br>ApexSQL Manage<br>ApexSQL Mask<br>ApexSQL Model<br>ApexSQL Monitor<br>ApexSQL Plan<br>ApexSQL Propagate<br>ApexSQL Pump<br>ApexSQL Recover<br>ApexSQL Refactor<br>ApexSQL Script<br>ApexSQL Search<br>ApexSQL Source Control<br>ApexSQL Trigger<br>ApexSQL Unit Test</p><p></p>
Microsoft SQL Server 2022 Support for ApexSQL Log? - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Source Control Action Center: how can one ignore user changes and not default select - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Understand the true significance of "perpetual." - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Unable to download free trail ApexSql doc. - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
Unable to download free trail ApexSQL Devops Plus toolkit for ApexSQL doc - Forum - ApexSQL - Quest Community
Toad ... My Service Requests ... Policies & Procedures Consulting Services Microsoft Platform Management Data Protection Unified Endpoint Management Performance Monitoring
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All