Transactional Replication Won't Stop Running -- sql server replication

BSandia
10/20/2004 12:37:16 PM

I have a publication that is being pulled and when I execute a UPDATE command
example: UPDATE Oils SET Description = 'This is a description'

The SQL Query Analyzer completes the command successfully.
I am receiving confirmation that more than 30,0000 rows have been updated
when I run this command.

When I go to the Replication Manager and view the Subscription it continues
to run indefinitely.

In some cases more than 8 hrs.

Are there some parameters that might need to be set when running this
process?

Any feedback is appreciated.

Thank you

Hilary Cotter
10/20/2004 4:07:29 PM

is your agent configured to run continuously?

This might account for this phenomena.

[quoted text, click to view]

sql server replication : Transactional Replication Won't Stop Running