Pending transaction -- sql server replication

stephanie
3/21/2006 2:31:06 AM

Thanks for reply. Which field indicate the transaction is completed?
I found that there are 5 enties in the result but in 'view synchronization
status' stating 'No replicated transactions are available'. Thanks in advance

[quoted text, click to view]

Paul Ibison
3/28/2006 12:00:00 AM

Stephanie,
please try this: SELECT transaction_timestamp,*
FROM [dbo].[MSreplication_subscriptions]
Delete the last 8 zeros and use this as the timestamp value.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

stephanie
3/28/2006 1:17:01 AM

sorry, what will the argument for showing the timestamp? i have search
through online book and ms web site but can't find any hints on it. Thanks a
lot

[quoted text, click to view]

stephanie
3/31/2006 1:00:01 AM

I found a system view 'MSdistribution_status' and the column
'undelivcmdsindistdb' show pending transactions in subscriber. Does it mean
that the pending transaction which hold/queue in distributor but not yet
delivered to subscriber?

Please correct me if I am wrong. Thanks

[quoted text, click to view]

Paul Ibison
4/8/2006 8:54:04 PM

Stephanie,
this is a useful view, but it shows aggregated data and not this individual
commands - not sure if that is what you really want.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

stephanie
4/11/2006 1:42:02 AM

Actually, we will stop all replication during batch time and restart the jobs
after the batch finished. If we want to confirm all data delivered to
subscribe after restart the replication jobs, can we simply use this command

select * from MSdistribution_status where undelivcmdsindistdb <>0

Thanks in advance.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Pending transaction