Is there any command to check out any outstanding transactions not yet replicated to subscriber DB Thanks in advance
Pending transaction
Hot Topic
- Failure installing SQL Server 2005 SP 1
- exporting reports into EXCEL format
- failed connect to mirror instance
- SCD and populating dimensions and facts
- Uninstall utility error "ISCLUSTERED"
- Strange Problem: .sdf 128MB filesize limit
- SQL Authentication issue
- Hundreds Of VIEWS
- Database Diagrams - SQL Server 2005 Express
- Error locating server/instance specified
SQL Server
- how to know status of previous control flow
- .NET Database/General Performance
- Bug in SQL Server 2000 with OPENXML?
- warning when altering the column length
- Package Configurations not so portable?
- Access denied
- Trigger question
- performance of indexed views
- data not flowing out of flat file source
- Comparing two dimensions
Pending transaction
Sunchaser
Ville
To see what commands have not been picked up by the logreader agent, use sp_repltrans.
To see what commands have not been picked up by the distribution agent, it's kind of a hack - find the last xact_seqno in the MSdistribution _history table for the given distribution agent. Then plug it into sp_browsereplcmds (@xact_sequno_start) along with @publisher_database_id to list all the commands not replicated yet. This is a good estimate, but not exact.