Recently came across a situation where the DB2 subscriber was failing with the below <error>DB2OLEDBV2: Error "System.DllNotFoundException: Unable to load DLL 'mseidrda.dll': The specified module could not be found</error> DB2 provider was installed from the SQL Server 2008's feature pack...

* sp_addPublication procedure for creating a new transactional replication has a parameter @immediate_sync. BOL has description about it as: <BOL> @immediate_sync=] 'immediate_synchronization' Specifies if the synchronization files for the publication are created each time the Snapshot Agent runs...