Posts

Showing posts from September, 2012

Replication Commands

/* Run all the below commands in Distribution database. When the distribution Agent job is stopped */ USE distribution go SELECT * from MSrepl_transactions order by entry_time desc /*It gives the transaction and command details Don't give xact_seqno in single quotes */ select * From MSrepl_commands where xact_seqno = 0x0000003000000010001A GO /* Column value here coming from the column of command in MSRepl_commands table,give here xact_seqno_start in single quotes */ exec sp_browsereplcmds @command_id = 1 , @xact_seqno_start = '0x0000003000000010001A' , @xact_seqno_end = '0x0000003000000010001A' , @publisher_database_id = 2 go EXEC sp_replmonitorsubscriptionpendingcmds @publisher = 'RAMESH' , @publisher_db = 'ADHOC' , @Publication = 'Adhoc' , @Subscriber = 'RAMESH\TEST' , @Subscriber_db = 'Adhoc' , ...