Open up replication monitor, right click on your subscription in the right
hand pain. And select View Details. Then go to the menu item Action and
Distribution/or Merge Agent job properties. Click on the Steps tab, double
"georgeg" <ggg@hotamil.com> wrote in message
news:7971732E-18AC-46B7-8246-185A11FC0A8C@microsoft.com...
> How do you this on sql server 2005? The information supplied is for 2000.
>
> Thanks,
> --
> George Gopie
>
>
>
> "Hilary Cotter" wrote:
>
>> Enable logging to determine exactly what is causing this message.
>>
>>
http://support.microsoft.com/default.aspx?scid=kb;en-us;312292&sd=tech >>
>> --
>> Hilary Cotter
>> Director of Text Mining and Database Strategy
>> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>>
>> This posting is my own and doesn't necessarily represent RelevantNoise's
>> positions, strategies or opinions.
>>
>> Looking for a SQL Server replication book?
>>
http://www.nwsu.com/0974973602.html >>
>> Looking for a FAQ on Indexing Services/SQL FTS
>>
http://www.indexserverfaq.com >>
>>
>>
>> "georgeg" <ggg@hotamil.com> wrote in message
>> news:0EDA5533-779B-4E66-8FA9-1A5D1A0B3CDF@microsoft.com...
>> >I was creating a new transactional publication and new subscriber on the
>> >same
>> > server. The snapshot agent works OK, but the Log Reader is giving this
>> > error
>> > The process could not execute 'sp_repldone/sp_replcounters' on
>> > 'SPRS76'.
>> > The
>> > server name is sprs76.
>> >
>> > I am now trying to remove the publication and its just hangs and would
>> > not
>> > return any messages.
>> >
>> > I have used exec sp_droppublication @publication='<publication name>'
>> >
>> > There are other publications and subscriptions ther are working OK on
>> > this
>> > server.
>> > There is also one distributor database on theis server.
>> >
>> > Thanks for your help.
>> > --
>> > George Gopie
>> >
>>
>>
>>
