Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Getting pending replicated transactions in Distribution Database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-10 : 09:26:16
Sadeem writes "i m using SQL Server 2000 and OS is Win 2K server.

my qs is regarding SQL Server Replication. i m using transactional replication.

sp_repltrans
Returns a result set of all the transactions in the publication database transaction log that are marked for replication but have not been marked as distributed. This stored procedure is executed at the Publisher on a publication database.

But i want to know a way how to inquire about all the transactions in distribution database which is not yet committed to all the subscribers?"
   

- Advertisement -