SELECT [name], database_id, is_cdc_enabled FROM sys.databases

GO

EXEC sys.sp_cdc_enable_db

GO

EXEC sys.sp_cdc_disable_table

@source_schema = N'Masi',

@source_name = N'UserRole',

@capture_instance = N'Masi_UserRole'

GO

exec sys.sp_cdc_enable_table

@source_schema = 'Masi',

@source_name = 'UserAccount' ,

@role_name = 'Masi_UserAccount',

@supports_net_changes = 1

SELECT name, type, type_desc, is_tracked_by_cdc FROM sys.tables

GO

declare @begin_lsn binary(10), @end_lsn binary(10)

-- get the first LSN for customer changes

select @begin_lsn = sys.fn_cdc_get_min_lsn('Masi_UserAccount')

-- get the last LSN for customer changes

select @end_lsn = sys.fn_cdc_get_max_lsn()

-- get net changes; group changes in the range by the pk

--print @begin_lsn

--print @end_lsn

update enterpriseservice.cdclsnlowerbound

set lsnlowerbound = @begin_lsn

where captureinstancename = 'Masi_UserAccount'

select * from enterpriseservice.cdclsnlowerbound