January 9, 2008 at 3:23 am
Hi,
Can any one help me out on how to find out the Pending transactions for Subscriber in a Replication environment.
The problem is my replication is taking huge time to drain the transactions. I need to check how many and what transactions are there in pending tray.
Do SQL Server 2005 maintains any table where we can get the pending transactions to be applied in subscriber.
January 10, 2008 at 6:20 am
SQL Server 2005 Books Online (September 2007)
sp_repltrans (Transact-SQL)
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.
or
DBCC OPENTRAN (Transact-SQL)
Displays information about the oldest active transaction and the oldest distributed and nondistributed replicated transactions, if any, within the specified database. Results are displayed only if there is an active transaction or if the database contains replication information. An informational message is displayed if there are no active transactions.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply