2012年2月19日星期日

Disable sp_MSadd_merge_history

Hi Guys,
I'm currently running a dynamic snapshot replication over a 56k modem. I
have built the snapshot and inserted the snapshot file to a USB key and
applying the snapshot from the USB Key. The problem I am encountering is
that, for every script file that is applied to the local database this sp
get fired to the Head Office server exec sp_MSadd_merge_history, is there
anyway I can disable this for an install as I can't take the server with us.
I dialup to the head office server so authentication can take place, but the
exec sp_MSadd_merge_history is slowing things down a lot.
Thanks Tim.
no, this proc is necessary for tracking information.
"Tim Ford" <tford@.in2focusnospam.com> wrote in message
news:u1mlBUdMEHA.3664@.TK2MSFTNGP10.phx.gbl...
> Hi Guys,
> I'm currently running a dynamic snapshot replication over a 56k modem. I
> have built the snapshot and inserted the snapshot file to a USB key and
> applying the snapshot from the USB Key. The problem I am encountering is
> that, for every script file that is applied to the local database this sp
> get fired to the Head Office server exec sp_MSadd_merge_history, is there
> anyway I can disable this for an install as I can't take the server with
us.
> I dialup to the head office server so authentication can take place, but
the
> exec sp_MSadd_merge_history is slowing things down a lot.
> Thanks Tim.
>

没有评论:

发表评论