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 2005 Forums
 Replication (2005)
 pending transactions

Author  Topic 

thaniparthi.rao
Yak Posting Veteran

96 Posts

Posted - 2008-05-15 : 11:52:34
i have a small doubt
where to see the pending transactions in transactional replication

For a database can we have multiple publications

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-15 : 12:26:15
1) I think sp_repltrans and DBCC opentran to find open transactions.

2) Yes you can have multiple pubs for 1 database.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-15 : 22:13:27
You can find them in replication monitor.
Go to Top of Page
   

- Advertisement -