Icon SET UPDATES STORE

Sets the current updates store used for configuration queries.

Syntax
SET UPDATES STORE TO <StoreName>

Usage
Use this statement to set the current updates store. The current updates store dictates where ElevateDB will retrieve the list of avalable updates when queries on the Updates Table in the special Configuration Database are executed. The name provided must be a valid store name. You can find out which stores exist by querying the Stores Table in the Configuration database.

Information This statement is not persistent and is reset once the current session is disconnected.

Please see the Replication topic for more information on loading/saving updates for a database.

Examples
SET UPDATES STORE TO "RemoteOffice"

Required Privileges
Any user can execute this statement.

SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:

DeviationDetails
ExtensionThis SQL statement is an ElevateDB extension.
Image