SQL Guide : System stored procedures : System stored procedures for advanced replication : SYNC_GET_CATALOG_SYNC_ NODE_NAME_AND_MODE
  
SYNC_GET_CATALOG_SYNC_ NODE_NAME_AND_MODE
The SYNC_GET_CATALOG_SYNC_NODE_NAME_AND_MODE system stored procedure is used internally for advanced replication housekeeping.
See also
System stored procedures for advanced replication