Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

UserOptions Properties

(see also Protected Properties )
  Name Description
ms220724.pubproperty(en-US,SQL.90).gif AbortOnArithmeticErrors
Gets or sets the Boolean property value that specifies whether arithmetic divide by zero errors are terminated or not.
ms220724.pubproperty(en-US,SQL.90).gif AbortTransactionOnError
Gets or sets the Boolean property value that specifies whether transactions are automatically terminated or not.
ms220724.pubproperty(en-US,SQL.90).gif AnsiNullDefaultOff
Gets or sets the Boolean property value that specifies whether new columns created allow null values by default or not.
ms220724.pubproperty(en-US,SQL.90).gif AnsiNullDefaultOn
Gets or sets the Boolean property value that specifies whether new columns created allow null values by default or not.
ms220724.pubproperty(en-US,SQL.90).gif AnsiNulls
Gets or sets the Boolean property value that specifies whether null values can be used in comparisons or not.
ms220724.pubproperty(en-US,SQL.90).gif 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.
ms220724.pubproperty(en-US,SQL.90).gif 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.
ms220724.pubproperty(en-US,SQL.90).gif 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.
ms220724.pubproperty(en-US,SQL.90).gif CursorCloseOnCommit
Gets or sets the Boolean property value that specifies whether any open cursors are closed when a transaction is committed or rolled back.
ms220724.pubproperty(en-US,SQL.90).gif 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.
ms220724.pubproperty(en-US,SQL.90).gif IgnoreArithmeticErrors
Gets or sets the Boolean property value that specifies whether error messages are generated or not when divide by zero errors occur.
ms220724.pubproperty(en-US,SQL.90).gif 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.
ms220724.pubproperty(en-US,SQL.90).gif NoCount
Gets or sets the Boolean property value that specifies whether queries return the number of rows affected.
ms220724.pubproperty(en-US,SQL.90).gif NumericRoundAbort
Gets or sets the Boolean property value that specifies whether an error is generated when loss of precision occurs in an expression.
ms220724.pubproperty(en-US,SQL.90).gif Parent
Gets the Server object that is the parent of the UserOptions object.
ms220724.pubproperty(en-US,SQL.90).gif Properties 
Gets a collection of Property objects that represent the object properties.
(inherited from SqlSmoObject )
ms220724.pubproperty(en-US,SQL.90).gif QuotedIdentifier
Gets or sets the Boolean property value that specifies whether double or single quotation marks can be used to delimit identifiers or not.
ms220724.pubproperty(en-US,SQL.90).gif State 
Gets the state of the referenced object.
(inherited from SmoObjectBase )
ms220724.pubproperty(en-US,SQL.90).gif Urn 
Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.
(inherited from SqlSmoObject )
ms220724.pubproperty(en-US,SQL.90).gif UserData 
Gets or sets user-defined data associated with the referenced object.
(inherited from SmoObjectBase )

  Name Description
ms220724.protproperty(en-US,SQL.90).gif ExecuteForScalar 
Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option.
(inherited from SqlSmoObject )
ms220724.protproperty(en-US,SQL.90).gif ObjectInSpace 
Gets the Boolean property value that specifies whether the object exists in isolation or whether it is connected to the instance of Microsoft SQL Server directly or indirectly.
(inherited from SqlSmoObject )
ms220724.protproperty(en-US,SQL.90).gif PresetProperties 
Gets or sets the preset properties of the referenced object.
(inherited from SqlSmoObject )
ms220724.protproperty(en-US,SQL.90).gif ScalarResult 
Gets the scalar result for the referenced object.
(inherited from SqlSmoObject )

Community Additions

ADD
Show:
© 2015 Microsoft