While replicating a Merge type, on one table F_Subdtl1 (No. of records 25,00,000), the snapshot gives an error "Timeout Expired". This error comes in as soon as the snapshot is being started.
I have already increased Query Timeout to 0 and Login timeout=45.
I'm using SqlServer 2000.
I thought the problem might be because of adding a "rowid" to it, so I did that also... but still the snapshot gives an error and starting all over again.
Please help me out in replicating the two databases.