UserOptions 类
The UserOptions object represents a set configurable server options that relate specifically to users.
继承层次结构
System. . :: . .Object
Microsoft.SqlServer.Management.Smo. . :: . .SmoObjectBase
Microsoft.SqlServer.Management.Smo. . :: . .SqlSmoObject
Microsoft.SqlServer.Management.Smo..::..UserOptions
命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
<SfcElementTypeAttribute("UserOption")> _
Public NotInheritable Class UserOptions _
Inherits SqlSmoObject _
Implements IAlterable, IScriptable, ISfcSupportsDesignMode
用法
Dim instance As UserOptions
[SfcElementTypeAttribute("UserOption")]
public sealed class UserOptions : SqlSmoObject,
IAlterable, IScriptable, ISfcSupportsDesignMode
[SfcElementTypeAttribute(L"UserOption")]
public ref class UserOptions sealed : public SqlSmoObject,
IAlterable, IScriptable, ISfcSupportsDesignMode
[<SealedAttribute>]
[<SfcElementTypeAttribute("UserOption")>]
type UserOptions =
class
inherit SqlSmoObject
interface IAlterable
interface IScriptable
interface ISfcSupportsDesignMode
end
public final class UserOptions extends SqlSmoObject implements IAlterable, IScriptable, ISfcSupportsDesignMode
UserOptions 类型公开以下成员。
属性
名称 | 说明 | |
---|---|---|
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 | 获取或设置 Boolean 属性值,该值指定对象是否设置为针对标量选项执行。 (从 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 | 获取 Boolean 属性值,该值指定在服务器上对象属性是否已更新但尚未持久化。 (从 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 | 获取 Boolean 属性值,该值指定对象是否单独存在,或者对象是否直接或间接连接到 SQL Server 的实例。 (从 SqlSmoObject 继承。) | |
Parent | Gets the Server object that is the parent of the UserOptions object. | |
Properties | 获取表示对象属性的 Property 对象的集合。 (从 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 | 获取所引用对象的标量结果。 (从 SqlSmoObject 继承。) | |
State | Gets the state of the referenced object. (从 SmoObjectBase 继承。) | |
Urn | 获取唯一标识对象的统一资源名称 (URN) 地址值。 (从 SqlSmoObject 继承。) | |
UserData | Gets or sets user-defined data associated with the referenced object. (从 SmoObjectBase 继承。) |
页首
方法
页首
事件
名称 | 说明 | |
---|---|---|
PropertyChanged | 表示更改属性时发生的事件。 (从 SqlSmoObject 继承。) | |
PropertyMetadataChanged | 表示属性元数据更改时发生的事件。 (从 SqlSmoObject 继承。) |
页首
字段
名称 | 说明 | |
---|---|---|
m_ExtendedProperties | 表示一个属性,可以对该属性进行定义以便扩展 SqlSmoObject 提供的属性。 (从 SqlSmoObject 继承。) | |
singletonParent | 表示单一父级。 (从 SqlSmoObject 继承。) |
页首
显式接口实现
页首
注释
To get or set UserOptions object properties, users can be a member of the public fixed server role. The setting applies to the current user.
Thread Safety
此类型的任何公共静态(Microsoft Visual Basic 中的 Shared)成员在多线程操作中是安全的。不保证所有实例成员都是线程安全的。
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。