asked
Blockquote formatting not working
If I try to use the block quoting format (manually typed a greater-than symbol), like in this question: > The cleanup job is initiated by running the parameterless stored procedure sp_MScdc_cleanup_job. This stored procedure starts by extracting the configured retention and threshold values for the cleanup job from msdb.dbo.cdc_jobs. The retention value is used to compute a new low watermark for the change tables. The specified number of minutes is substracted from the maximum tran_end_time value from the cdc.lsn_time_mapping table to obtain the new low water mark expressed as a datetime value. The CDC.lsn_time_mapping table is then used to convert this datetime value to a corresponding lsn value. If the same commit time is shared by multiple entries in the table, the lsn that corresponds to the entry that has the smallest lsn is chosen as the new low watermark. This lsn value is passed to sp_cdc_cleanup_change_tables to remove change table entries from the database change tables. Then it shows good in the preview as I type the question, but doesn't hold the formatting when I post the question
This should now be resolved.
Strangely if I do a smaller quote, it works > small quote Had to post this as an answer, as the formatting for the whole question is somehow broken now
Also If I use the button to apply the quote, it messes up a large quote: > The cleanup job is initiated by > running the parameterless stored > procedure sp_MScdc_cleanup_job. This > stored procedure starts by extracting > the configured retention and threshold > values for the cleanup job from > msdb.dbo.cdc_jobs. The retention value > is used to compute a new low watermark > for the change tables. The specified > number of minutes is substracted from > the maximum tran_end_time value from > the cdc.lsn_time_mapping table to > obtain the new low water mark > expressed as a datetime value. The > CDC.lsn_time_mapping table is then > used to convert this datetime value to > a corresponding lsn value. If the same > commit time is shared by multiple > entries in the table, the lsn that > corresponds to the entry that has the > smallest lsn is chosen as the new low > watermark. This lsn value is passed to > sp_cdc_cleanup_change_tables to remove > change table entries from the database > change tables.
14 People are following this question.
