Tag Info

New answers tagged


You do not mention whether you are using SQL Server 2012 or 2014, however the documentation on CDC and Change Tracking do not show much difference. Both make the following statement: "CDC configuration is always performed on the current or intended primary replica." http://msdn.microsoft.com/en-us/library/hh403414(v=sql.120).aspx#CDC The above link is ...


Here is the MSDN Large Object Data Types Columns of data type image, text, and ntext are always assigned a NULL value when __$operation = 1 or __$operation = 3. Columns of data type varbinary(max), varchar(max), or nvarchar(max) are assigned a NULL value when __$operation = 3 unless the column changed during the update. When __$operation = 1, these columns ...

Top 50 recent answers are included