You can configure a Microsoft Dynamics NAV database by creating a Microsoft SQL Server configuration parameter table. You need to enter parameters into the table to determine the behavior that will be used when using this database.
Creating a Configuration Parameter Table
To create a configuration parameter table, in the database create a table owned by dbo, as shown in the following code.
 Copy Code |
|
|---|---|
CREATE TABLE [$ndo$dbconfig] (config VARCHAR(512) NOT NULL) GRANT SELECT ON [$ndo$dbconfig] TO public |
|
You can add additional columns to this table, if necessary. The length of the config column should be large enough to contain the necessary configuration values, (512 is used in this example).
There is one record in this table for each required parameter.