none
Msg 8115, Level 16, State 2, Procedure sp_MSsetupnosyncsubscriptionwithlsn, Arithmetic overflow error converting expression to data type nvarchar.

    Question

  • 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? 


    • Edited by DeepaV Friday, July 12, 2013 11:04 AM
    Friday, July 12, 2013 11:03 AM

All replies