Problem Description:
I have two servers (server 1:192.168.0.0.10, server 2:192.168.0.11). The 2008 version of sqlserver is installed on both servers, but these two databases are not master-slave libraries. Now I want to turn on the table CDC function on server 1. By default, after turning on the table CDC and the library CDC, a schema named CDC will be generated under the current library, and some tables will be generated under the schema, such as captured_ columns,change_ tables,ddl_ history,table_ CT, etc. Please ask, "do I have parameters to configure other server addresses in the SQL of opening the CDC table in Server1, so that the table that I should have automatically generated under Server1 can be generated on server2"? Does sqlserver support this function at present?
