Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
The SQL Remote tab of the Database property sheet has the following components:
This database has a publisher Select this option to supply the name of the database's publisher. Selecting this option enables the Publisher field below.
Publisher Shows the name of the publisher for the database. You can click Change to select a publisher in the Set Publisher dialog.
This remote database has a corresponding consolidated database Select this option if the database is acting as a remote database.
Consolidated user Click Change to select the consolidated user from the list of available candidates in the Set Consolidated User dialog.
Message type Select the message type for communicating with the publisher from the dropdown list.
For information about the message types supported by SQL Remote, see Using message types.
Address Provides a place for you to type the remote address of the consolidated user. The address is a string, according to the specified message type, to which the replication messages should be sent for the user.
Send frequency Select one of the following options for the send frequency:
Send then close Sets the replication frequency so that the Message Agent runs once, sends all pending messages, and then shuts down. The Message Agent must be restarted each time the publisher wants to send messages. This option is only useful when you are running the Message Agent at a remote site.
In most replication setups, this option is not used for sending publications from the consolidated publisher to the remote group.
Send every Select this option to set the replication frequency so that the Message Agent runs continuously, sending messages to this consolidated user at the given periodic interval. This option is useful at both consolidated and remote sites.
Send daily at Select this option to set the replication frequency so that the Message Agent runs continuously, sending messages each day at the given time.
Subscribers Shows the number of remote users subscribing to publications in the database.
Subscriptions Shows the number of subscriptions to publications in the database.
Started subscriptions Shows the number of subscriptions in the database that have been started.