Configuring SQL Server in SMO

In SMO, the Information object, the Settings object, the UserOptions object, and the Configuration object settings and information for the instance of Microsoft SQL Server.

SQL Server has numerous properties that describe the behavior of the installed instance. The properties describe the startup options, the server defaults, files and directories, system and processor information, product and versions, connection information, memory options, language and collation selections, and the authentication mode.

SQL Server Configuration

The Information object properties contain information about the instance of SQL Server, such as processor and platform.

The Settings object properties contain information about the instance of SQL Server. The default database file and directory can be modified in addition to the Mail Profile and the Server Account. These properties remain for the duration of the connection.

The UserOptions object properties contain information about the current connections behavior relating to arithmetic, ANSI standards, and transactions.

There is also a set of configuration options that is represented by the Configuration object. It contains a set of properties that represent the options that can be modified by the sp_configure stored procedure. Options such as Priority Boost, Recovery Interval and Network Packet Size control the performance of the instance of SQL Server. Many of these options can be changed dynamically, but in some cases the value is first configured and then changed when the instance of SQL Server is restarted.

There is a Configuration object property for every configuration option. Using the ConfigProperty object you can modify the global configuration setting. Many properties have maximum and minimum values that are also stored as ConfigProperty properties. These properties require the Alter method to commit the change to the instance of SQL Server.

All of the configuration options in the Configuration object must be changed by the system administrator.

See Also

Other Resources

sp_configure (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance