Skip to content

Instantly share code, notes, and snippets.

@cassioeskelsen

cassioeskelsen/ativando_cdc_por_tabela.sql

Last active April 10, 2022 23:57
Show Gist options
  • Save cassioeskelsen/14b31d198e29a09bf4a81353c93d1ad2 to your computer and use it in GitHub Desktop.
Save cassioeskelsen/14b31d198e29a09bf4a81353c93d1ad2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ativando_cdc_por_tabela.sql
EXEC sys.sp_cdc_enable_table
@source_schema = N'Faturamento'
@source_name = N'NotasFiscais',
@role_name = N'CDC_Reader',
@capture_instance = N'NotasFiscais001',
@supports_net_changes = 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment