Şöyle yaparız
# Enable CDC for database “demodb”USE demodbGOEXEC sys.sp_cdc_enable_table# Enable the data capture on the source table@source_schema = N'dbo',@source_name = N'Inventory',@role_name = NULL,@supports_net_changes = 0GO
# Enable CDC for database “demodb”USE demodbGOEXEC sys.sp_cdc_enable_table# Enable the data capture on the source table@source_schema = N'dbo',@source_name = N'Inventory',@role_name = NULL,@supports_net_changes = 0GO
SELECT CASE WHEN ( ( ( @@OPTIONS & 512 ) = 512 ) ) THEN 'ON' ELSE 'OFF' END AS XACT_ABORT_STATUS; -- When XAC...
No comments:
Post a Comment