- It looks like you're doing a manual initialization of the subscription

If so did you specify @sync_type='replication support only' in

sp_addsubscription statement ?

- What is...

Thank you for all your replies.

Actually my question was not posted properly, it is actually : Is it normal that varchar variable is trimmed automatically in comparison (...