It does not force you to initialize, but it does invalidate any unreplicated transactions in the transaction log which will potentially put you in an out of sync condition.

In...

If you run sp_repldone, you will mark all the transactions in the transaction log as replicated, and logreader will now ignore them. So, if there have been any transactions that...

Thanks, Paul. I just wanted to provide some additional "color" to...

A key consideration in this space is where the code contributors are aligned, as that is a major factor when looking at any open source solution. All of the 3...

Heh - the way you phrased that it seems like you are referring to them...

What do you see when you run dbcc opentran(YourDBName)? Check the SPID that shows in the output.

A better answer from this technet article;

[ @replicate_ddl = ] replicate_ddl

Indicates if schema replication is supported for the publication. replicate_ddl is int, with a default of 1 for SQL...

Read the last post on this thread.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/81b28f4a-58b1-4092-a2a4-69e435e1316f/ddl-still-replicates-even-with-ddl-replication-off-replicateddl-0?forum=sqlreplication

Thanks, Wayne. I'll check that out. I have a working version from what was shared earlier but will try to implement this in the next few days. Since we...

This is so COOL! I was starting to look at how to do this and thought "I'll just search it to see if anyone has done this..." and WOW! Works...

I haven't had to convert a whole environment before but definitely a couple servers in an environment. Your plan sounds good and you should realize some time savings in the...

Ah - Glad you found something that works. 🙂

There are a couple tables that you can query; msdb..sysreplicationalerts and distribution.dbo.MSrepl_errors. Both are on the distribution server. Let me know if that doesn't give you the information you need....

Do you have any of the CU's installed? You might want to check out the documentation for 2012 SP1 CU6. There is an interesting fix noted in this article http://support.microsoft.com/kb/2877100

Unfortunately, no, there isn't a way to control this.