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_
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_
3. Does Cloud SQL for SQL Server support Change Data Capture feature?
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/ef4d8e29-f8ca-42bc-9955-59f4ac4d9297%40googlegroups.com.
No comments:
Post a Comment