Change tracking

USE [DATABASE_NAME];
CREATE LOGIN artie WITH PASSWORD = 'PASSWORD';
CREATE USER artie FOR LOGIN artie;
ALTER LOGIN artie ENABLE;
GRANT SELECT on DATABASE::DATABASE_NAME to artie;
GO;

USE [DATABASE_NAME];
ALTER DATABASE [DATABASE_NAME]
SET CHANGE_TRACKING = ON
-- Specify the retention period of your Change Tracking tables.
-- We recommend you setting this between 24h to 7 days
(CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON);

ALTER TABLE [TABLE NAME] ENABLE CHANGE_TRACKING;

DECLARE @object_id INT;
DECLARE @change_table_name NVARCHAR(MAX);
DECLARE @sqlCommand NVARCHAR(MAX);

SET @object_id = OBJECT_ID([TABLE NAME]);
SET @change_table_name = (SELECT TOP 1 name FROM sys.internal_tables where parent_object_id = @object_id);
SET @sqlCommand = N'EXEC sp_spaceused N''' + 'sys.' + @change_table_name + N'''';
EXEC sp_executesql @sqlCommand;