| |
Name
|
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. |