Sets the current files store used for configuration queries.

Syntax

---

SET FILES STORE TO <StoreName>

Usage

---

Use this statement to set the current files store. The current files store dictates where ElevateDB will retrieve the list of avalable filess when queries on the Files 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.


Examples

---

SET FILES 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: