Settings 成員

The Settings object represents a group of configurable settings on the instance of SQL Server.

Settings 型別公開下列成員。

方法

	名稱	描述
	AddDatabaseContext	(繼承自 SqlSmoObject。)
	Alter	Updates any Settings object property changes on the instance of SQL Server.
	AlterImpl	(繼承自 SqlSmoObject。)
	AlterImplFinish	(繼承自 SqlSmoObject。)
	AlterImplInit	(繼承自 SqlSmoObject。)
	AlterImplWorker	(繼承自 SqlSmoObject。)
	BindDefaultImpl	(繼承自 SqlSmoObject。)
	BindRuleImpl	(繼承自 SqlSmoObject。)
	CheckCollation	(繼承自 SqlSmoObject。)
	CheckObjectState() () () ()	Validates the state of the referenced object. (繼承自 SqlSmoObject。)
	CheckObjectState(Boolean)	Validates the state of the referenced object with the option to specify that an exception is thrown if the object is not yet created. (繼承自 SqlSmoObject。)
	CheckObjectStateImpl	(繼承自 SqlSmoObject。)
	CheckVersion100	(繼承自 SqlSmoObject。)
	CheckVersion80	Checks the validity of the object on SQL Server 2000. (繼承自 SqlSmoObject。)
	CheckVersion80SP3	Checks the validity of the object on SQL Server 2000 SP3. (繼承自 SqlSmoObject。)
	CheckVersion90	Check the validity of the object on SQL Server 2005. (繼承自 SqlSmoObject。)
	CheckVersionBelow90	(繼承自 SqlSmoObject。)
	CleanObject	(繼承自 SqlSmoObject。)
	CreateImpl	(繼承自 SqlSmoObject。)
	CreateImplFinish	(繼承自 SqlSmoObject。)
	CreateImplInit	(繼承自 SqlSmoObject。)
	Discover	(繼承自 SqlSmoObject。)
	DropImpl	(繼承自 SqlSmoObject。)
	DropImplWorker	(繼承自 SqlSmoObject。)
	EnumScriptImpl	(繼承自 SqlSmoObject。)
	EnumScriptImplWorker	(繼承自 SqlSmoObject。)
	Equals	(繼承自 Object。)
	Finalize	(繼承自 Object。)
	FormatSqlVariant	(繼承自 SqlSmoObject。)
	GenerateDataSpaceFileStreamScript	(繼承自 SqlSmoObject。)
	GenerateDataSpaceScript	(繼承自 SqlSmoObject。)
	GetBindDefaultScript	(繼承自 SqlSmoObject。)
	GetBindRuleScript	(繼承自 SqlSmoObject。)
	GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%)	(繼承自 SqlSmoObject。)
	GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean)	(繼承自 SqlSmoObject。)
	GetDateTimeParameter	(繼承自 SqlSmoObject。)
	GetDateTimeParameterAsInt	(繼承自 SqlSmoObject。)
	GetDBName	Gets the database name that is associated with the object. (繼承自 SqlSmoObject。)
	GetEnumParameter	(繼承自 SqlSmoObject。)
	GetFragOptionString	(繼承自 SqlSmoObject。)
	GetGuidParameter	(繼承自 SqlSmoObject。)
	GetHashCode	(繼承自 Object。)
	GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%)	(繼承自 SqlSmoObject。)
	GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean)	(繼承自 SqlSmoObject。)
	GetPropValue	(繼承自 SqlSmoObject。)
	GetPropValueOptional	(繼承自 SqlSmoObject。)
	GetPropValueOptionalAllowNull	(繼承自 SqlSmoObject。)
	GetRealValue	(繼承自 SqlSmoObject。)
	GetScriptingOptionsForCreate	(繼承自 SqlSmoObject。)
	GetServerName	Gets the name of the instance of SQL Server with which the object is associated. (繼承自 SqlSmoObject。)
	GetServerObject	(繼承自 SqlSmoObject。)
	GetSqlServerVersionName	Gets the version name of the instance of SQL Server with which the object is associated. (繼承自 SqlSmoObject。)
	GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%)	(繼承自 SqlSmoObject。)
	GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean)	(繼承自 SqlSmoObject。)
	GetTimeSpanParameterAsInt	(繼承自 SqlSmoObject。)
	GetType	(繼承自 Object。)
	GetUrnRecursive(StringBuilder)	(繼承自 SqlSmoObject。)
	GetUrnRecursive(StringBuilder, UrnIdOption)	(繼承自 SqlSmoObject。)
	ImplInitialize	(繼承自 SqlSmoObject。)
	Initialize() () () ()	Initializes the object and forces the properties be loaded. (繼承自 SqlSmoObject。)
	Initialize(Boolean)	Initializes the object and forces the properties be loaded. (繼承自 SqlSmoObject。)
	IsObjectDirty	Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of SQL Server. (繼承自 SqlSmoObject。)
	IsObjectInitialized	Verifies whether the object has been initialized. (繼承自 SqlSmoObject。)
	IsObjectInSpace	Verifies whether the object is isolated or connected to the instance of SQL Server. (繼承自 SqlSmoObject。)
	IsVersion80SP3	(繼承自 SqlSmoObject。)
	MarkDropped	(繼承自 SqlSmoObject。)
	MarkForDropImpl	(繼承自 SqlSmoObject。)
	MemberwiseClone	(繼承自 Object。)
	PostAlter	(繼承自 SqlSmoObject。)
	PostCreate	(繼承自 SqlSmoObject。)
	PostDrop	(繼承自 SqlSmoObject。)
	Refresh	Refreshes the object and retrieves properties when the object is next accessed. (繼承自 SqlSmoObject。)
	Script() () () ()	Generates a Transact-SQL script that can be used to re-create the SQL Server settings.
	Script(ScriptingOptions)	Generates a Transact-SQL script that can be used to re-create the SQL Server settings as specified by the scripting options.
	ScriptAlter	(繼承自 SqlSmoObject。)
	ScriptCreate	(繼承自 SqlSmoObject。)
	ScriptDdl	(繼承自 SqlSmoObject。)
	ScriptDrop	(繼承自 SqlSmoObject。)
	ScriptImpl() () () ()	(繼承自 SqlSmoObject。)
	ScriptImpl(ScriptingOptions)	(繼承自 SqlSmoObject。)
	ScriptImplWorker	(繼承自 SqlSmoObject。)
	SetParentImpl	(繼承自 SqlSmoObject。)
	ToString	Returns a String that represents the referenced object. (繼承自 SqlSmoObject。)
	TouchImpl	(繼承自 SqlSmoObject。)
	UnbindDefaultImpl	(繼承自 SqlSmoObject。)
	UnbindRuleImpl	(繼承自 SqlSmoObject。)
	Validate	(繼承自 SmoObjectBase。)

頂端

欄位

	名稱	描述
	m_ExtendedProperties	(繼承自 SqlSmoObject。)

頂端

屬性

	名稱	描述
	AuditLevel	Gets or sets the audit level for the instance of Microsoft SQL Server.
	BackupDirectory	Gets the default backup directory for the instance of Microsoft SQL Server.
	DefaultFile	Gets or sets the default data file directory for the instance of Microsoft SQL Server.
	DefaultLog	Gets or sets the default log file directory for the instance of Microsoft SQL Server.
	ExecuteForScalar	Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (繼承自 SqlSmoObject。)
	IsTouched	Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (繼承自 SqlSmoObject。)
	LoginMode	Gets or sets the logon mode for SQL Server.
	MailProfile	Gets or sets the mail profile for the instance of SQL Server.
	NumberOfLogFiles	Gets or sets the number of log files used by databases on the instance of SQL Server.
	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。)
	OleDbProviderSettings	References a collection of OleDbProviderSettings objects. Each OleDbProviderSettings object represents an OLE DB provider setting.
	Parent	Gets the Server object that is the parent of the Settings object.
	PerfMonMode	Gets the polling behavior of Performance Monitor on the instance of SQL Server.
	Properties	Gets a collection of Property objects that represent the object properties. (繼承自 SqlSmoObject。)
	ScalarResult	Gets the scalar result for the referenced object. (繼承自 SqlSmoObject。)
	State	Gets the state of the referenced object. (繼承自 SmoObjectBase。)
	TapeLoadWaitTime	Gets or sets the time to wait for a tape to load on a tape backup device.
	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。)

頂端

事件

	名稱	描述
	PropertyChanged	(繼承自 SqlSmoObject。)
	PropertyMetadataChanged	(繼承自 SqlSmoObject。)

頂端

明確繼承實作  

	名稱	描述
	IAlienObjectDiscover	(繼承自 SqlSmoObject。)
	IAlienObjectGetParent	(繼承自 SqlSmoObject。)
	IAlienObjectGetProperty	(繼承自 SqlSmoObject。)
	ISfcPropertyProviderGetPropertySet	(繼承自 SqlSmoObject。)
	IAlienObjectGetUrn	(繼承自 SqlSmoObject。)
	IAlienObjectResolve	(繼承自 SqlSmoObject。)
	IAlienObjectSetProperty	(繼承自 SqlSmoObject。)

頂端

請參閱

參考

Settings類別

Microsoft.SqlServer.Management.Smo 命名空間