Also u might want to try to increase number of retries for replication jobs...

Stacy,

Thank you so much!!!   It's finnally working... I got my first emails from productions...

Borik

Let hope this will help others as well...

Stacy thanks again for a quick reply... i am still getting the error...

here is the code that i am executing... any other suggestions would be really apreciated...

Hi Stacy, thanks for the help but i still get the error here is the code that i have now...

It works gret on my localInstall but on server it just...

has any one seen solution to this problem??? I am on Win2003/Sql2000 using remote SMPT

server with no smtp running on sql box...

thanks.

Is there a web based tools like this???

Borik

try

DBCC dbreindex(table),

this might take some time and table will be locked...

other option to defragment the index...

some how i think it related to fragmented index and/or pages

Borik

Try this

1. Query->Show Execution Plan

2. Run both queries in one window

3. it will tell you how much time each query took out of execution of hole Batch,

plus you see what...

NoLock - Doesn't crate any locks on anything...

so you might get partial info if some one inserting

or updating data at the time.

From BON(NOLOCK - Do not issue shared...

I got the same problme and running "sp_repldone with @reset = 1" didn't help

now i get

Another log reader is replicating the database.

(Source: TESQLSRV3 (Data source); Error number: 18752)

-----------------------------------------------------------------------------------

The process...

Enterprise Manager ->

Replication Monitor ->

Publishers ->

ServerName ->

Right Click on Publisher ->

General Tab ->

at the bottom there is Radio button "Subscription never expires..."

P.S. Unfortenetly i did't find how to resolve...

Thanks for reply, i have chenged the subscription not to exprire now would be nice to find a easy way to fix replication, with out droping it and recreating it...

if...

Well it transactional replication so it does replicate constantly... and i think it set to never expire, can't find where to check....

also what the steps i need to take...

Umm i just got this error "The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated."

any Help to get this...