--SQL Server Database log full due to replication, you can run the following command to mark all ---the replication transaction is done, it will let you shrink the log file.
exec sp_repldone @xactid = NULL, @xact_seqno = NULL, @numtrans = 0, @time = 0, @reset = 1;
--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...
--disable cdc master --Table Contains list of all the tables where cdc needs to be disabled - [dba].dbo.replication_cdc_table --execute...
select schema_name(tab.schema_id) as [schema_name], pk.[name] as pk_name, substring(column_names, 1, len(column_names)-1) as [columns],...
Comments