I've read elsewhere that a DDL trigger on the source database can cause problems with this but

a.) change-control forbids me to disable a trigger that is logging DB changes

b.) must...

I can understand that the underlying problem was caused by some dynamic SQL in the DDL trigger but it can't be seen as a solution to this issue disabling and...

I've searched all 10 cumulative updates for SP3 and there is no mention of a fix for this issue with ANSI_PADDING OFF in the replication *.sch files. This is definitely...

I had this same error when trying to initialise a Subscription. I checked the <subname>.sch file on the Publisher and noticed SET ANSI_PADDING OFF.

I amended the file to SET ANSI_PADDING...

The problem is you cannot connect to the SQL Instance using SSMS when it is running in single-user mode?

In that case, what happens if you restore a TranLog backup where the Time range of the Transaction Logs 'overlap' a full or differential backup? What happens to the changes...