I am using cloud sql MS Sql server and I have enabled Change Tracking on database and on a table. I am able to capture the changes on the table as expected. I kept retention period as 10 minutes with auto cleanup ON, but unfortunately auto cleanup is not clearing 10 minutes old changes from the change table.
Then I tried manual cleanup using sp_flush_CT_internal_table_on_demand and it returned a message "Only members of the sysadmin fixed server role can perform this operation." I understand in Cloud SQL for SQL Server, the sysadmin role is not supported. Below are my questions.
1. Does Cloud SQL for SQL Server fully support Change Tracking feature? If so why auto cleanup is not working as expected?
2. Is there any alternate way to execute T-SQL commands (like sp_flush_CT_internal_table_on_demand) which needs sysadmin privilege?
3. Does Cloud SQL for SQL Server support Change Data Capture feature?