ABS
- Oct 23, 2021
- 1 min read

SQL - List of tables which enable change tracking

select sys.schemas.name as Schema_name, sys.tables.name as Table_name from sys.change_tracking_tables

join sys.tables on sys.tables.object_id = sys.change_tracking_tables.object_id

join sys.schemas on sys.schemas.schema_id = sys.tables.schema_id

Recent Posts

Check inventory audit in SAP select a.CreateDate, b.USER_CODE as [User], a.TransType SAP_DocType, case when a.TransType = 13 then 'Sale Invoice' when a.TransType = 14 then 'Sale Credit Note' when a

iVend Integration Configuration Error: Object reference not set to an instance of an object

ivend-SAP Integration Monitor from SBO to ivend Query

Select IntegrationKey,Cast(SourceType AS Varchar(20)) As SourceType,SourceKey, OperationType, isNull(LogDatetime, getdate()) As LogDatetime, Case isNull(Status, 0) When 0 Then 'Not Processed' Else 'Fa

Post: Blog2_Post