Created
October 9, 2025 19:34
-
-
Save MarkPryceMaherMSFT/d6db267c933ce9311f938f54d5a530a9 to your computer and use it in GitHub Desktop.
Code to materialise the stored proc sp_help_change_feed
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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