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