Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

UserOptions Properties

The UserOptions type exposes the following members.

  Name Description
Public property AbortOnArithmeticErrors Gets or sets the Boolean property value that specifies whether arithmetic divide by zero errors are terminated or not.
Public property AbortTransactionOnError Gets or sets the Boolean property value that specifies whether transactions are automatically terminated or not.
Public property AnsiNullDefaultOff Gets or sets the Boolean property value that specifies whether new columns created allow null values by default or not.
Public property AnsiNullDefaultOn Gets or sets the Boolean property value that specifies whether new columns created allow null values by default or not.
Public property AnsiNulls Gets or sets the Boolean property value that specifies whether null values can be used in comparisons or not.
Public property 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.
Public property 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.
Public property 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.
Public property CursorCloseOnCommit Gets or sets the Boolean property value that specifies whether any open cursors are closed when a transaction is committed or rolled back.
Public property 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.
Public property IgnoreArithmeticErrors Gets or sets the Boolean property value that specifies whether error messages are generated or not when divide by zero errors occur.
Public property 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.
Public property NoCount Gets or sets the Boolean property value that specifies whether queries return the number of rows affected.
Public property NumericRoundAbort Gets or sets the Boolean property value that specifies whether an error is generated when loss of precision occurs in an expression.
Public property Parent Gets the Server object that is the parent of the UserOptions object.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public property QuotedIdentifier Gets or sets the Boolean property value that specifies whether double or single quotation marks can be used to delimit identifiers or not.
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Top
  Name Description
Explicit interface implemetation Private property ISfcSupportsDesignMode.IsDesignMode Gets a Boolean value that indicates whether the object supports design mode. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
Top
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.