The above mentioned method will work but if you need to update the existing record if it exist with new value and insert if it does not, use the UPSERT...

Thanks to both of you. Appreciate it..:)

Why dont you try using sp_getapplock. That could help with the dead lock issue.

Roy

Hi Gagandeep,

I have been having this error for nearly threee weeks now. The replication is working fine. A bit slow for my liking but still it works. The problem with...