Many many thanks for the reply. All the information available on those sites are very helpful.

Both the replications from Server 1 to Server 2 and Server 2 to Server 3(Remote) are Merge publication using PUSH option. All the 3 tables which required to be replicated...

Dear,

I understood but How to Scriptout the SP & Functions in to a text file?

We were having two SQL 2000 Standard (Below SP3 Service Pack) server whrere merge replication was giong on (Windows NT Server 4.0). We want to upgrade the system with new...