SQL Guide : System stored procedures : System stored procedures for advanced replication : SYNC_DELETE_MESSAGES
  
SYNC_DELETE_MESSAGES
The SYNC_DELETE_MESSAGES system stored procedure deletes hanging messages in the replica database. There might be several hanging messages if a replica application creates messages and does not check and handle errors properly.
CALL SYNC_DELETE_MESSAGES (
  replica_catalog_name,    -- WVARCHAR
)
EXECUTES ON: replica.
You must have administrator or synchronization administrator access rights to execute this stored procedure.
If replica_catalog_name is NULL, the current catalog is used.
This procedure does not return a resultset.
RC
Text
Description
13047
No privilege for operation
 
13133
Not a valid license for this product.
 
25005
Message is already active.
 
25009
Replica not found.
 
25019
Database is not a replica database
 
25020
Database is not a master database.
 
25035
Message is in use.
 
Related reference
”SYNC_DELETE_REPLICA_MESSAGES
See also
System stored procedures for advanced replication