While subscribing from SQL 2012 to SQL 2008 R2 subscriber getting the error:
Arithmetic overflow error converting expression to data type nvarchar.
Msg 8115, Level 16, State 2, Procedure sp_MSsetupnosyncsubscriptionwithlsn, Line 237.
I had unsubscribed and tried resubscribing multiple times. Each time it tried to create subscription with new agentid and did not succeed. Looked like was running into issue
mentioned in http://support.microsoft.com/kb/948622
Had to remove all publications, and replication completely and add it all back. This time I did not run into any issues. Could this be a bug which I was running into?