Sql server configuration file parameters

Configuration options are marked with letter codes as follows:. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No.

Any additional feedback? Determines whether or not data will be stored in row or out of row for varbinary max columns in the adds table. If set to 0, up to 8, bytes can be stored directly in the data page of the table. If set to 1, data will always be stored out of row. Raster AUX table composite column index storage definition. Index type for any user-defined indexes on business table. Index type for xml doc type column of business table. Business table raster column index storage definition.

Business table spatial column index storage definition. Business table XML column index table storage definition. Determines whether or not data will be stored in row or out of row for varbinary max columns in a business table. Business table and raster attribute table storage definition. Raster BLK table composite column index storage definition. Determines whether or not data will be stored in row or out of row for varbinary max columns in the raster blocks table.

Raster BND table composite column index storage definition. Uses the database collation by default, unless other collation is specified. Feature table area column index storage definition. Feature table length column index storage definition.

Determines whether or not data will be stored in row or out of row for varbinary max columns in a feature f table. Adds a check constraint on the geometry column for an SRID value. Defines storage for the i tables, which are used to generate IDs.

Controls the SQL Server cursor threshold. For all other values, the SQL Server Query Optimizer compares the number of expected rows in the cursor set to the number set in the cursor threshold, then builds the keyset asynchronously if it exceeds the cursor threshold number. Controls amount of time in milliseconds the database can take to query the sysprotects table.

Spatial index table first index storage definition when using binary geometry storage. Spatial index table second index storage definition. Represents the spatial index table storage definition. User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of network configuration.

User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of terrain configuration. User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of associated noncomposite configuration keyword. User interface parameter, which indicates associated configuration keyword will appear in the ArcGIS user interface; contains description of topology configuration.

Determines whether Unicode text types will be used or not. Specifies the XML schema to be used for validation. Specifies the XML document type that a column can store. If you gave the catalog any other name, you must change the value of this parameter to match it. There is no default value set for this parameter. Consult your DBMS documentation for valid language settings. There are a number of ways to categorize configuration parameters.

Often, a parameter fits into more than one category. The following sections describe these categories. The business table is the attribute table of a feature class or nonspatial table. Business table parameters begin with B and define storage for the business table and its indexes. The parameters are as follows:. If set to 0, a nonclustered index is created. If set to 1, a clustered index is created.

Index type for any user-defined indexes on a business table. Index type for the XML type column of a business table. Index type for the raster column in a business table. Defines the fillfactor and location file group for the row ID column index of a business table. Defines the fillfactor and location file group for any user defined indexes on a business table. Defines the fillfactor and location file group for XML index on a business table. Defines the fillfactor and location file group for the raster column index on a business table.

If set to 0, up to 8, bytes are stored directly in the data page of the table. For a nonspatial business table, do one of the following:. An adds table is a table that stores insert and update edits made against a feature class in a geodatabase that uses traditional versioning. It is almost identical in structure to the business table but has additional columns to track state IDs.

Adds table parameters begin with A. The adds table parameters are as follows:. Index type for any user-defined indexes on an adds table. The processing order of the parameters while using the configuration file is outlined below:. The configuration file can be used to track the parameters and values for each installation. This makes the configuration file useful for verifying and auditing the installations.

The ConfigurationFile. Insert the SQL Server installation media. From the root folder, double-click Setup. To install from a network share, locate the root folder on the share, and then double-click Setup. The following command will start setup and create a configuration file. Follow the wizard through to the Ready to Install page. The path to the configuration file is specified in the Ready to Install page in the configuration file path section.

The setup infrastructure writes out all the appropriate parameters for the actions that were run, with the exception of sensitive information such as passwords. In addition, a value is included for Boolean parameters where a value is usually not supplied through the command prompt. This command line argument is not supported on an IA64 or a bit system. Specify 1 or True to enable and 0 or False to disable this feature. When ; Manual - Service startup is manual mode default.

Related Articles. Error code 0x84B Error Installing. NET 3. Popular Articles. Rolling up multiple rows into a single row and column for SQL Server data.

How to tell what SQL Server versions you are running. Resolving could not open a connection to SQL Server errors. Ways to compare and find differences for SQL Server tables and data.

Searching and finding a string value in all columns in a SQL Server table.