8/24/2023 0 Comments Cdc change data captureWhen CDC is enabled on a table, it creates two CDC-related jobs that are specific to the database, and executed using SQL Server Agent. Before enabling CDC at the table level, make sure that you have enabled SQL Server Agent. You can run the following stored procedure to enable each table. ![]() The above query will return a result that includes a column with the table name, along with a column which displays if CDC is enabled or not. First run following query to show which tables of database have already been enabled for CDC. It has to be enabled for any table which needs to be tracked. The CDC feature can be applied at the table-level to any database for which CDC is enabled.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |