Dynamic Snapshot Problem

Last Post 21 Mar 2005 06:34 AM by nyy22. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
nyy22
New Member
New Member

--
21 Mar 2005 06:34 AM
I have built a publication in which we have built our own filtered views that the replication views use to pull data for our customers. Each customer gets his own data based on a single view that uses the suser_name() operation. When I use a standard snapshot and let the customers replicate from their machines, everything works fine. I have now tried to convert it over to use Dynamic Snapshots (Because the initial load was taking over 2 hours). I have ran the Dynamic Snapshot, but for some reason, it is not loading any data at all. All my bcp files have no data in them at all. Building it for the first time still takes over 2 hours (Which is fine as long as the initial load to the customer is faster), but I'm not getting any data at all.

I can offer up more detail if needed, but if anyone has any recommendations on this, I would appreciate it.
You are not authorized to post a reply.

Acceptable Use Policy