Assume that you publish many tables (more than 1,000) by using snapshot or transactional replication. Snapshot Agent takes a long time to run, such as an hour, the agent may fail, and you may receive error messages that resemble the following:
Prefetch objects failed for Database ‘database_name’.
To work around this issue, add the parameter "-prefechtables 0" to the snapshot agent job.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.