GETDATE()

Use distribution;

Declare @PublisherDB sysname,
      @PublisherDBID int,
      @SeqNo nchar(22),
      @CommandID int

-- Set publisher database name and values from Replication Monitor
Set @PublisherDB = N'testDB'
Set @SeqNo = N'0x0000000000000000000000000000'
Set @CommandID = 0
 
-- Find the publisher database ID
Select @PublisherDBID = id
From dbo.MSpublisher_databases
Where publisher_db = @PublisherDB
 
-- Get the command
Exec sp_browsereplcmds
      @xact_seqno_start = @SeqNo,
      @xact_seqno_end = @SeqNo,
      @command_id = @CommandID,