Distribution schedule, change tracking is not enabled on table

In case of following errors:
Cannot execute the required database operation.
The SQL database has issued an error.
Object Server 01:
[Microsoft][SQL Server Native Client 11.0][SQL Server]Change tracking is not enabled on table
'INVENTSERIAL'.
Error happened during scheduler job execution. Check infolog for details.

Change tracking needs to be enabled for the specified table.
Open SQL Server Management Studio, connect to SQL server, select correct DB and in table properties enable change tracking:

Alternatively use SQL script:
use DbName;

IF NOT EXISTS (SELECT 1 FROM sys.change_tracking_tables WHERE object_id = OBJECT_ID('[dbo].[RETAILSTORELOCATORGROUPMEMBER]')) 
 BEGIN ALTER TABLE [dbo].[RETAILSTORELOCATORGROUPMEMBER] ENABLE CHANGE_TRACKING WITH (TRACK_COLUMNS_UPDATED = ON) END 

...
SQLQuery_ReActivateCT.txt

Support The Author

 If you found value in what I share, I've set up a Buy Me a Coffee page as a way to show your support.

Buy Me a Coffee

Post a Comment

   renew the code

All Comments

No comments. Be the first one to comment on this post.

Search

About

DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics AX.

Authors are allowed to set their own "buy me a coffee" link.
Join us.

Blog Tags