.png)
Settings Properties
The Settings type exposes the following members.
| Name | Description | |
|---|---|---|
|
AuditLevel | Gets or sets the audit level for the instance of Microsoft SQL Server. |
|
|
BackupDirectory | Gets the default backup directory for the instance of Microsoft SQL Server. |
|
|
DefaultFile | Gets or sets the default data file directory for the instance of Microsoft SQL Server. |
|
|
DefaultLog | Gets or sets the default log file directory for the instance of Microsoft SQL Server. |
|
|
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Inherited from SqlSmoObject.) |
|
|
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Inherited from SqlSmoObject.) |
|
|
LoginMode | Gets or sets the logon mode for SQL Server. |
|
|
MailProfile | Gets or sets the mail profile for the instance of SQL Server. |
|
|
NumberOfLogFiles | Gets or sets the number of log files used by databases on the instance of SQL Server. |
|
|
ObjectInSpace | Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (Inherited from SqlSmoObject.) |
|
|
OleDbProviderSettings | References a collection of OleDbProviderSettings objects. Each OleDbProviderSettings object represents an OLE DB provider setting. |
|
|
Parent | Gets the Server object that is the parent of the Settings object. |
|
|
PerfMonMode | Gets the polling behavior of Performance Monitor on the instance of SQL Server. |
|
|
Properties | Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.) |
|
|
ScalarResult | Gets the scalar result for the referenced object. (Inherited from SqlSmoObject.) |
|
|
State | Gets the state of the referenced object. (Inherited from SmoObjectBase.) |
|
|
TapeLoadWaitTime | Gets or sets the time to wait for a tape to load on a tape backup device. |
|
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.) |
|
|
UserData | Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.) |
