按一下以給予評分及指教

  開啟低頻寬檢視
社群內容
本節內容
數據 註解 (0)
其他版本也適用於下列軟體:
Server Properties

(see also Protected Properties )
  名稱 Description
ms220267.pubproperty(zh-tw,SQL.100).gif ActiveDirectory
Gets information about the Active Directory settings for the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif AuditLevel
Gets or sets the AuditLevel property value.
ms220267.pubproperty(zh-tw,SQL.100).gif Audits
Represents a collection of Audit objects. Each Audit object represents an audit log defined on the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif BackupDevices
Represents a collection of BackupDevice objects. Each BackupDevice object represents a backup device defined on the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif BackupDirectory
Gets or sets the BackupDirectory property value.
ms220267.pubproperty(zh-tw,SQL.100).gif BrowserServiceAccount
Gets the service account that the Browser service runs under on the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif BrowserStartMode
Gets the start mode for the SQL Server Browser Service running on the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif BuildClrVersion
Gets the BuildClrVersion property value.
ms220267.pubproperty(zh-tw,SQL.100).gif BuildClrVersionString
Gets the BuildClrVersionString property value.
ms220267.pubproperty(zh-tw,SQL.100).gif BuildNumber
Gets the BuildNumber property value.
ms220267.pubproperty(zh-tw,SQL.100).gif Collation
Gets the Collation property value.
ms220267.pubproperty(zh-tw,SQL.100).gif CollationID
Gets the CollationID property value.
ms220267.pubproperty(zh-tw,SQL.100).gif ComparisonStyle
Gets the ComparisonStype property value.
ms220267.pubproperty(zh-tw,SQL.100).gif ComputerNamePhysicalNetBIOS
Gets the ComputerNamePhysicalNetBIOS property value.
ms220267.pubproperty(zh-tw,SQL.100).gif Configuration
Gets the configuration options for the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif ConnectionContext
Gets the current server connection details for the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif Credentials
Represents a collection of Credential objects. Each Credential object represents a credential defined on the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif CryptographicProviders
Gets the CryptographicProviders property value.
ms220267.pubproperty(zh-tw,SQL.100).gif Databases
Represents a collection of Database objects. Each Database object represents a database defined on the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif DefaultFile
Gets or sets the DefaultFile property value.
ms220267.pubproperty(zh-tw,SQL.100).gif DefaultLog
Gets or sets the DefaultLog property value.
ms220267.pubproperty(zh-tw,SQL.100).gif DefaultTextMode
Gets or sets the Boolean property value that specifies whether the default text mode is set for the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif Edition
Gets the Edition property value.
ms220267.pubproperty(zh-tw,SQL.100).gif Endpoints
Represents a collection of Endpoint objects. Each Endpoint object represents an endpoint defined on the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif EngineEdition
Gets the EngineEdition property value.
ms220267.pubproperty(zh-tw,SQL.100).gif ErrorLogPath
Gets the ErrorLogPath property value.
ms220267.pubproperty(zh-tw,SQL.100).gif Events
Gets the server events that are associated with the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif FilestreamLevel  
ms220267.pubproperty(zh-tw,SQL.100).gif FilestreamShareName  
ms220267.pubproperty(zh-tw,SQL.100).gif FullTextService
Gets the Microsoft Search Full-Text service implementation for the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif Information
Gets information about the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif InstallDataDirectory
Gets the local Windows directory where the installation data is stored for the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif InstallSharedDirectory
Gets the remote shared directory where the installation data is stored for the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif InstanceName
Gets the instance name of the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif IsCaseSensitive
Gets the IsCaseSensitive property value.
ms220267.pubproperty(zh-tw,SQL.100).gif IsClustered
Gets the IsClustered property value.
ms220267.pubproperty(zh-tw,SQL.100).gif IsFullTextInstalled  
ms220267.pubproperty(zh-tw,SQL.100).gif IsSingleUser
Gets the IsSingleUser property value.
ms220267.pubproperty(zh-tw,SQL.100).gif JobServer
Gets the SQL Server Agent associated with the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif Language
Gets the Language property value.
ms220267.pubproperty(zh-tw,SQL.100).gif Languages
Represents a collection of Language objects. Each Language object represents an languages supported by the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif LinkedServers
Represents a collection of LinkedServer objects. Each LinkedServer object represents a linked server registered on the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif LoginMode
Gets or sets the ServerLoginMode property value.
ms220267.pubproperty(zh-tw,SQL.100).gif Logins
Represents a collection of Login objects. Each Login object represents a login defined on the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif Mail
Gets the Microsoft SQL Mail service associated with the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif MailProfile
Gets or sets the MailProfile property value.
ms220267.pubproperty(zh-tw,SQL.100).gif MasterDBLogPath
Get the MasterDBLogPath property value.
ms220267.pubproperty(zh-tw,SQL.100).gif MasterDBPath
Gets the MasterDBPath property value.
ms220267.pubproperty(zh-tw,SQL.100).gif MaxPrecision
Gets the MaxPrecision property value.
ms220267.pubproperty(zh-tw,SQL.100).gif Name
Gets the name of the server, which is the physical machine name.
ms220267.pubproperty(zh-tw,SQL.100).gif NamedPipesEnabled
Gets the Boolean value that specifies whether Named Pipes provider is enabled for client-server connectivity on the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif NetName
Gets the NetName property value.
ms220267.pubproperty(zh-tw,SQL.100).gif NumberOfLogFiles
Gets or sets the NumberOfLogFiles property value.
ms220267.pubproperty(zh-tw,SQL.100).gif OleDbProviderSettings
Gets the DbProviderSettings property value.
ms220267.pubproperty(zh-tw,SQL.100).gif OSVersion
Gets the OSVersion property value.
ms220267.pubproperty(zh-tw,SQL.100).gif PerfMonMode
Gets or sets the PerfMonMode property value.
ms220267.pubproperty(zh-tw,SQL.100).gif PhysicalMemory
Gets the PhysicalMemory property value.
ms220267.pubproperty(zh-tw,SQL.100).gif Platform
Gets the Platform property value.
ms220267.pubproperty(zh-tw,SQL.100).gif Processors
Gets the Processors property value.
ms220267.pubproperty(zh-tw,SQL.100).gif Product
Gets the Product property value.
ms220267.pubproperty(zh-tw,SQL.100).gif ProductLevel
Gets the ProductLevel property value.
ms220267.pubproperty(zh-tw,SQL.100).gif Properties 
Gets a collection of Property objects that represent the object properties.
(inherited from SqlSmoObject )
ms220267.pubproperty(zh-tw,SQL.100).gif ProxyAccount
Gets the proxy account associated with the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif ResourceGovernor
Gets the ResourceGovernor property value.
ms220267.pubproperty(zh-tw,SQL.100).gif ResourceLastUpdateDateTime
Gets the ResourceLastUpdateDateTime property value.
ms220267.pubproperty(zh-tw,SQL.100).gif ResourceVersion
Gets the ResourceVersion property.
ms220267.pubproperty(zh-tw,SQL.100).gif ResourceVersionString
Gets the ResouceVersionString property value.
ms220267.pubproperty(zh-tw,SQL.100).gif Roles
Represents a collection of ServerRole objects. Each ServerRole object represents a role defined on the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif RootDirectory
Gets the RootDirectory property value.
ms220267.pubproperty(zh-tw,SQL.100).gif ServerAuditSpecifications  
ms220267.pubproperty(zh-tw,SQL.100).gif ServerType
Gets the server type for the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif ServiceAccount
Gets the service account under which the instance of SQL Server is running.
ms220267.pubproperty(zh-tw,SQL.100).gif ServiceInstanceId
Gets the ID value that uniquely identifies the service instance for this instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif ServiceMasterKey
Gets the service master key associated with the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif ServiceName  
ms220267.pubproperty(zh-tw,SQL.100).gif ServiceStartMode  
ms220267.pubproperty(zh-tw,SQL.100).gif Settings
Gets modifiable settings for the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif SqlCharSet
Gets the SqlCharSet property value.
ms220267.pubproperty(zh-tw,SQL.100).gif SqlCharSetName
Gets the SqlCharSetName property value.
ms220267.pubproperty(zh-tw,SQL.100).gif SqlDomainGroup  
ms220267.pubproperty(zh-tw,SQL.100).gif SqlSortOrder
Gets the SqlSortOrder property value.
ms220267.pubproperty(zh-tw,SQL.100).gif SqlSortOrderName
Gets the SqlSortOrderName property value.
ms220267.pubproperty(zh-tw,SQL.100).gif State 
Gets the state of the referenced object.
(inherited from SmoObjectBase )
ms220267.pubproperty(zh-tw,SQL.100).gif Status  
ms220267.pubproperty(zh-tw,SQL.100).gif SystemDataTypes
Represents a collection of SystemDataType objects. Each SystemDataType object represents a system data type defined on the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif SystemMessages
Represents a collection of SystemMessage objects. Each SystemMessage object represents a system message defined on the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif TapeLoadWaitTime
Gets or sets the TapeLoadWaitTime property value.
ms220267.pubproperty(zh-tw,SQL.100).gif TcpEnabled  
ms220267.pubproperty(zh-tw,SQL.100).gif Triggers
Represents a collection of ServerDdlTrigger objects. Each ServerDdlTrigger object represents a server data definition language (DDL) trigger that is defined on the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif Urn 
Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.
(inherited from SqlSmoObject )
ms220267.pubproperty(zh-tw,SQL.100).gif UserData 
Gets or sets user-defined data associated with the referenced object.
(inherited from SmoObjectBase )
ms220267.pubproperty(zh-tw,SQL.100).gif UserDefinedMessages
Represents a collection of UserDefinedMessage objects. Each UserDefinedMessage object represents a user-defined message defined on the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif UserOptions
Gets the user options for the current connection to the instance of SQL Server.
ms220267.pubproperty(zh-tw,SQL.100).gif Version
Gets the Version property value.
ms220267.pubproperty(zh-tw,SQL.100).gif VersionMajor
Gets the VersionMajor property value.
ms220267.pubproperty(zh-tw,SQL.100).gif VersionMinor
Gets the VersionMinor property value.
ms220267.pubproperty(zh-tw,SQL.100).gif VersionString
Gets the VersionString property value.
  名稱 Description
ms220267.protproperty(zh-tw,SQL.100).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 )
ms220267.protproperty(zh-tw,SQL.100).gif 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 )
ms220267.protproperty(zh-tw,SQL.100).gif 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 )
ms220267.protproperty(zh-tw,SQL.100).gif ScalarResult 
Gets the scalar result for the referenced object.
(inherited from SqlSmoObject )
社群內容   什麼是社群內容?
新增內容 RSS  註解
Processing
© 2009 Microsoft Corporation. 著作權所有,並保留一切權利。 使用規定  |  商標  |  隱私權聲明
Page view tracker