sys.sp_wait_for_database_copy_sync

Description

This procedure is scoped to an Active Geo-Replication relationship between a primary and causes the application to wait until all committed transactions are replicated and acknowledged by the active secondary database.

Syntax

sys.sp_wait_for_database_copy_sync

Examples

Example 1

sys.sp_wait_for_database_copy_sync

Example 2

sp_wait_for_database_copy_sync

Example 3

sp_wait_for_database_copy_sync

Example 4

AdventureWorks

Example 5

serverSecondary

Example 6

USE
AdventureWorks;
GO
EXECUTE sys.sp_wait_for_database_copy_sync
@target_server = N
'serverSecondary'
,
@target_database = N
'AdventureWorks'
;
GO