tag:blogger.com,1999:blog-9075786158122089104.post5613891754754432050..comments2023-10-23T19:47:51.926+05:30Comments on SQL-Server Blog of Ritesh Shah --Fight the fear of SQL with SQLHub.com: Msg 22926, Level 16, State 1, Procedure sp_cdc_verify_capture_instance, Line 36 Could not create a capture instance because the capture instance name 'dbo_ChangeDataCapture' already exists in the current database. Specify an explicit unique name for the parameter @capture_instance.Ritesh Shahhttp://www.blogger.com/profile/09562656548324468450noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-9075786158122089104.post-13509210080421812902014-03-11T20:15:59.676+05:302014-03-11T20:15:59.676+05:30SELECT [name], database_id
FROM master.sys.databas...SELECT [name], database_id<br />FROM master.sys.databases WHERE is_cdc_enabled =1 <br /><br />Table_name<br />VODResourcesPackageMap<br />VODResourceDetails<br /><br />EXEC sys.sp_cdc_help_change_data_capture<br /><br />source_schema source_table capture_instance object_id source_object_id start_lsn end_lsn supports_net_changes has_drop_pending role_name index_name filegroup_name create_date index_column_list captured_column_list<br />dbo VODResourceDetails dbo_VODRESOURCEDETAILS 267147997 1205579333 0x0000233F00001F320001 NULL 0 NULL CDC_Role NULL CDC_FileGroup 2014-01-27 15:31:28.267 NULL [ResourceId], [ProviderAssetId], [Type], [HD], [ScreenFormat], [Culture], [Content], [BranchId], [EffectiveDate], [Active]<br />NULL NULL dbo_VODRESOURCEGENRE 347148282 1189579276 0x0000233F00001F320001 NULL 0 NULL CDC_Role NULL CDC_FileGroup 2014-01-27 15:31:28.437 NULL [ReportingInsertDate], [ResourceId], [Genre], [BranchId]<br />dbo VODResourcesPackageMap dbo_VODRESOURCESPACKAGEMAP 427148567 210099789 0x0000233F00001F320001 NULL 0 NULL CDC_Role NULL CDC_FileGroup 2014-01-27 15:31:28.687 NULL [PackageId], [ResourceId], [BranchId], [EffectiveDate], [Active]<br /><br />How do you delete the bad record?Ronhttps://www.blogger.com/profile/06753378066897672164noreply@blogger.com