UserOptions Members
Include Protected Members
Include Inherited Members
The UserOptions object represents a set configurable server options that relate specifically to users.
The UserOptions type exposes the following members.
Methods
Top
Properties
Name | Description | |
---|---|---|
![]() |
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. |
![]() |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Inherited from 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. (Inherited from 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. (Inherited from 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. (Inherited from 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. (Inherited from SqlSmoObject.) |
![]() |
State | Gets the state of the referenced object. (Inherited from SmoObjectBase.) |
![]() |
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.) |
Top
Events
Name | Description | |
---|---|---|
![]() |
PropertyChanged | (Inherited from SqlSmoObject.) |
![]() |
PropertyMetadataChanged | (Inherited from SqlSmoObject.) |
Top
Explicit Interface Implementations
Name | Description | |
---|---|---|
![]() ![]() |
IAlienObjectDiscover() | (Inherited from SqlSmoObject.) |
![]() ![]() |
IAlienObjectGetParent() | (Inherited from SqlSmoObject.) |
![]() ![]() |
IAlienObjectGetProperty(String) | (Inherited from SqlSmoObject.) |
![]() ![]() |
ISfcPropertyProviderGetPropertySet() | (Inherited from SqlSmoObject.) |
![]() ![]() |
IAlienObjectGetUrn() | (Inherited from SqlSmoObject.) |
![]() ![]() |
IAlienObjectResolve(String) | (Inherited from SqlSmoObject.) |
![]() ![]() |
IAlienObjectSetProperty(Object, Object) | (Inherited from SqlSmoObject.) |
Top