Şö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
Örnek Şöyle yaparız CREATE NONCLUSTERED INDEX IDX_MYINDEX ON Orders(OrderDate, ProductID);
No comments:
Post a Comment