To enhance the stability of cloud databases and the security of data migration, TencentDB for SQL Server provides an enhanced security protection trigger feature. This feature enforces strict limitation policies on specific types of triggers. Please read the following details.

In TencentDB for SQL Server, only the following triggers can be migrated, created, or modified:

CREATE_PROCEDURE, ALTER_PROCEDURE, DROP_PROCEDURE

CREATE_FUNCTION, ALTER_FUNCTION, DROP_FUNCTION

CREATE_STATISTICS, DROP_STATISTICS, UPDATE_STATISTICS

DDL_TABLE_EVENTS, DDL_VIEW_EVENTS, and other DDL event groups

Triggers other than the types listed above cannot be created or modified.

If a migrated file contains triggers other than those listed above, the triggers are automatically deleted after the migration is completed.

We apologize for any inconvenience and appreciate your trust and support for Tencent Cloud.

[TencentDB for SQL Server] Announcement on the Limitations for Creating, Modifying, and Migrating Risky Triggers

Update to Exam Appointment Rescheduling and Cancellation Policy

[Simple Email Service]Notice on Adjustment to Domain Reputation Upgrade Frequency Policy

tencent cloud