Example 2: inbound queue

In this example, these commands were executed at a primary database, NYDS.nydb:

sp_setreplicate emp_queue, true
insert emp_queue
   values("123456789", "Davis", "Gen",
          "Process Engineer","1/1/95", 1111)
insert emp_queue
   values("987654321", "Irvine", "Ben",
          "Microwave Engineer","3/5/94", 2222)
grant all on emp_queue to public

To view the inbound queue of the primary Replication Server:

sysadmin dump_queue, 102,1,-1,1,-2