July 22, 2008 at 12:00 pm
I have a publication configured on one of my databases (SQL 2005 SP2) that has been running very well for about a month. Latencies are usually between 4 and 15 seconds.
There is only one subscriber that is being used for reporting.
A developer asked today to have some additional stored procs replicated so I add them to "object to publish". They are set to replicate definition only.
Replication Monitor shows that my latency is currently 3 sec. However, the SPs which were published a couple of hours ago are still not visible (and cannot be called) on the subscriber.
Any ideas?
Thanks,
Chris
July 22, 2008 at 12:37 pm
Did you generate a snapshot? You have to generate a snapshot for the DDL to create the procedures to be generated.
July 24, 2008 at 7:53 am
No, I had not generated a snapshot. I did so through the "View Snapshot Agent Status" by hitting start. Now I can see the SPs on the subscriber.
Thank you!
-Chris
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply