Removing Replicate artifacts from the database
In order to capture DDLs, Qlik Replicate creates various artifacts in the SQL Server database when the task starts. When the task completes, you may wish to remove these artifacts.
To remove the artifacts, execute the following statements (in the order they appear below), where dbo is the default schema in which the artifacts were created:
Information noteThe event trigger does not belong to a specific schema.
DROP TRIGGER [attrep_mscdc_ddl_catcher] ON DATABASE
DROP TABLE [dbo].[attrep_mscdc_ddl_history]