UserOptions 成員
The UserOptions object represents a set configurable server options that relate specifically to users.
UserOptions 型別公開下列成員。
方法
.gif "受保護的方法")
.gif "公用方法")
頂端
.gif "受保護的欄位")
屬性
| 名稱 | 描述 | |
|---|---|---|
.gif "公用屬性") |
AbortOnArithmeticErrors | Gets or sets the Boolean property value that specifies whether arithmetic divide by zero errors are terminated or not. |
|
AbortTransactionOnError | Gets or sets the Boolean property value that specifies whether transactions are automatically terminated or not. |
|
AnsiNullDefaultOff | Gets or sets the Boolean property value that specifies whether new columns created allow null values by default or not. |
|
AnsiNullDefaultOn | Gets or sets the Boolean property value that specifies whether new columns created allow null values by default or not. |
|
AnsiNulls | Gets or sets the Boolean property value that specifies whether null values can be used in comparisons or not. |
|
AnsiPadding | Gets or sets the Boolean property value that specifies whether trailing blanks are inserted (padded) or removed (trimmed) in char, varchar, binary, and varbinary columns. |
|
AnsiWarnings | Gets or sets the Boolean property value that specifies whether warning messages are generated when nulls are encountered in aggregate functions such as SUM, AVG, MAX, MIN, STDEV, STDEVP, VAR, VARP, or COUNT. |
|
ConcatenateNullYieldsNull | Gets or sets the Boolean property value that specifies whether a value that is concatenated with a null value results in the value or a null value. |
|
CursorCloseOnCommit | Gets or sets the Boolean property value that specifies whether any open cursors are closed when a transaction is committed or rolled back. |
|
DisableDefaultConstraintCheck | Gets or sets the Boolean property value that specifies whether interim deferred violation checking is used when connecting to a server running Microsoft SQL Server version 6.x. |
.gif "受保護的屬性") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (繼承自 SqlSmoObject。) |
|
IgnoreArithmeticErrors | Gets or sets the Boolean property value that specifies whether error messages are generated or not when divide by zero errors occur. |
|
ImplicitTransactions | Gets or sets the Boolean property value that specifies whether a Transact-SQL transaction is started automatically after the previous transaction is committed or rolled back. |
|
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (繼承自 SqlSmoObject。) |
|
NoCount | Gets or sets the Boolean property value that specifies whether queries return the number of rows affected. |
|
NumericRoundAbort | Gets or sets the Boolean property value that specifies whether an error is generated when loss of precision occurs in an expression. |
|
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. (繼承自 SqlSmoObject。) |
|
Parent | Gets the Server object that is the parent of the UserOptions object. |
|
Properties | Gets a collection of Property objects that represent the object properties. (繼承自 SqlSmoObject。) |
|
QuotedIdentifier | Gets or sets the Boolean property value that specifies whether double or single quotation marks can be used to delimit identifiers or not. |
|
ScalarResult | Gets the scalar result for the referenced object. (繼承自 SqlSmoObject。) |
|
State | Gets the state of the referenced object. (繼承自 SmoObjectBase。) |
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (繼承自 SqlSmoObject。) |
|
UserData | Gets or sets user-defined data associated with the referenced object. (繼承自 SmoObjectBase。) |
頂端
.gif "公用事件")
明確繼承實作
| 名稱 | 描述 | |
|---|---|---|
.gif "明確介面實作") .gif "私用方法") |
IAlienObjectDiscover | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetParent | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetProperty | (繼承自 SqlSmoObject。) |
|
ISfcPropertyProviderGetPropertySet | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetUrn | (繼承自 SqlSmoObject。) |
|
IAlienObjectResolve | (繼承自 SqlSmoObject。) |
|
IAlienObjectSetProperty | (繼承自 SqlSmoObject。) |
頂端