Skip to content

Instantly share code, notes, and snippets.

@MarkPryceMaherMSFT

MarkPryceMaherMSFT/sp_help_change_feed.sql

Created October 9, 2025 19:34
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save MarkPryceMaherMSFT/d6db267c933ce9311f938f54d5a530a9 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save MarkPryceMaherMSFT/d6db267c933ce9311f938f54d5a530a9 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. MarkPryceMaherMSFT created this gist Oct 9, 2025.
    33 changes: 33 additions & 0 deletions sp_help_change_feed.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,33 @@
    IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[help_change_feed]') AND type in (N'U')) DROP TABLE [dbo].[help_change_feed]

    create table help_change_feed
    (
    table_group_id uniqueidentifier ,
    table_group_name nvarchar(140) ,
    destination_location nvarchar(512) ,
    destination_credential nvarchar(247) ,
    destination_type nvarchar(247) ,
    workspace_id nvarchar(247) ,
    synapse_workgroup_name nvarchar(247) ,
    enabled sysname ,
    max_message_size_bytes bigint ,
    partition_scheme nvarchar(247) ,
    schema_name nvarchar(247) ,
    table_name nvarchar(247) ,
    table_id uniqueidentifier ,
    table_object_id bigint ,
    state tinyint ,
    version binary(10) ,
    enable_lsn varchar(50) ,
    disable_lsn varchar(50) ,
    snapshot_phase tinyint ,
    snapshot_current_phase_time datetime ,
    snapshot_retry_count int ,
    snapshot_start_time datetime ,
    snapshot_end_time datetime ,
    snapshot_row_count int
    )
    insert into help_change_feed
    EXEC sp_help_change_feed;

    select * from help_change_feed ;