Navigation:  Advantage SQL > System Procedures > Procedures >

sp_TestReplicationConnection

Advantage SQL Engine

Previous pageReturn to chapter overviewNext page

Tests a subscriptions connection to the target database.

Syntax

sp_TestReplicationConnection( Subscription, CiCharacter, 200; )

Parameters

Subscription (I)

Subscription to test making a connection for

 

Output

ReturnCode (O)

Error code in the event of a failure.

ErrorMessage (O)

Error message in the event of a failure.

Remarks

sp_TestReplicationConnection can be used to test a subscription's ability to make a connection.

 

Example

 

EXECUTE PROCEDURE sp_TestReplicationConnection( 'sub1' );

See Also

sp_ModifySubscriptionProperty