In my tests, I enabled the FactInternetSales table in the AdventureWorksDW2008 sample database. SQL Server generated a table in the CDC schema named dbo_FactInternetSalees_CT to capture changes.

For this example, I’m choosing the AdventureWorksLT sample database as the source (Figure B). The next step is to create a server to host your SQL database.

At Microsoft's Ignite digital event this week, the company is announcing the private preview of SQL Server 2022, the next version of its three-decades-old relational database management system ...