Skip to content

Instantly share code, notes, and snippets.

@MarkPryceMaherMSFT
Created October 9, 2025 19:34
Show Gist options
  • Save MarkPryceMaherMSFT/d6db267c933ce9311f938f54d5a530a9 to your computer and use it in GitHub Desktop.
Save MarkPryceMaherMSFT/d6db267c933ce9311f938f54d5a530a9 to your computer and use it in GitHub Desktop.
Code to materialise the stored proc sp_help_change_feed
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 ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment