Prev: Field addition replication
Next: Replication via SMO/RMO - Error "class not registered"
From: venkat reddy venkat on 24 Jan 2010 07:31

i have configured transactional replication. Publisher and distributor on
same server ,when data is transmitted from distrubutor to subscriber the
query timeout error was occured and distribution agent is retrying to
transfer cmds.
Please suggest me on this error.


Thanks
venkat
From: Paul Ibison on 24 Jan 2010 13:25
I'd take a look at the subscriber database and see if there is any blocking
(sp_who2).
HTH,
Paul Ibison
From: NMahmoud on 30 Jan 2010 13:51
the account used for the "Subscriber Connection" should be a "dbo" in the
destination database.


"venkat reddy" <venkat reddy(a)discussions.microsoft.com> wrote in message
news:9312C9E8-62C7-484B-860A-02202C166D70(a)microsoft.com...
> i have configured transactional replication. Publisher and distributor on
> same server ,when data is transmitted from distrubutor to subscriber the
> query timeout error was occured and distribution agent is retrying to
> transfer cmds.
> Please suggest me on this error.
>
>
> Thanks
> venkat


 | 
Pages: 1
Prev: Field addition replication
Next: Replication via SMO/RMO - Error "class not registered"