Nice one, Steve. I downloaded this plug-in for my DBA SSMS.

I like Windows function, it just makes complex task simple. I use them all the time, I also wrote a column a while ago which explains all windows function available...

Very nice article.

Thanks for sharing this article. I had to implement such solution a while ago in my company.

Very well written.

Hi Doug,

All your questions are already answered in my previous posts of this topic forum.

Nice article.

Well, I disagree with what you are suggesting (see below for my responses):

akbar401 (7/25/2012)

---

Basit, First of all, You dont need to do suggest following things in your article.

1. truncate ms_replcmds...

Good introductory article.

Divine Flame (7/25/2012)

---

Thanks for sharing your thoughts Basit!

However, I would say I am not impressed with the solution provided to shrink the log file. As the article stats to gracefully...

Thanks Phil, Your comments taken.

Just to add to my last message that backup log is not a option in this situation because the issue is with LogReader.

“These transactions, such as uncommitted transactions, are not...

Chuck,

As I said, I've taken the full backup prior to performing the process. If I had to do the restore I can just restore the database from full backup. Below...

Chuck,

Well, the truncation of transaction log is the only option for this situation (which I could think off) because log reader is not reading the these transactions. I restarted the...

Chuck,

Well, the truncation of transaction log is the only option for this situation (which I can think off at that time) because log reader is not reading the these transactions....