Use this INTEGER parameter to specify the connection ID number for a connection on which the SYNCHRONIZE statement
was executed. If no value is specified, then the connection ID of the current connection is used.
Set this BIT parameter to 1 to have the stored procedure return information about completed synchronizations. Set the
parameter to 0 to return information about synchronizations that are currently active.
To view details of past or current synchronizations, you can use the sp_get_last_synchronize_result stored procedure as an
alternative to directly querying the synchronize_results global shared temporary table. The stored procedure only returns
the results of the last synchronization for the specified connection ID number. If you do not specify any parameters, the
last completed synchronization on the current connection is returned.
You can also use this stored procedure to monitor the progress of a synchronization on a connection that is different from
your current connection. To monitor the progress of a synchronization on a different connection:
Execute a SELECT CONNECTION_PROPERTY statement to determine the connection ID of your current connection.
Execute a SYNCHRONIZE statement using the connection ID returned by the SELECT CONNECTION_PROPERTY statement.
On a different connection, execute a SELECT CONNECTION_PROPERTY statement and set the @complete_only parameter to 0. Information about the last synchronization for the specified connection is returned, even if the synchronization