Server Properties
Include Protected Members
Include Inherited Members
The Server type exposes the following members.
Properties
Name | Description | |
---|---|---|
ActiveDirectory | Obsolete. Gets information about the Active Directory settings for the instance of SQL Server. | |
AffinityInfo | Gets the AffinityInfo object that is associated with an 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. | |
AvailabilityGroups | Gets the available groups in the 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 version string of the CLR that was used while building the instance. | |
BuildNumber | Gets the BuildNumber property value. | |
ClusterName | Gets the name of the cluster. | |
ClusterQuorumState | Gets the state of the cluster quorum. | |
ClusterQuorumType | Gets the type of the cluster quorum. | |
Collation | Gets the Collation property value. | |
CollationID | Gets the CollationID property value. | |
ComparisonStyle | Gets the Windows comparison style of the collation. | |
ComputerNamePhysicalNetBIOS | Gets the NetBIOS name of the local computer on which the instance of SQL Server is currently running. | |
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 list of server cryptographic providers. | |
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 default log of the server. | |
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 edition of the engine. | |
ErrorLogPath | Gets the ErrorLogPath property value. | |
Events | Gets the server events that are associated with the instance of SQL Server. | |
FilestreamLevel | Gets the level of FILESTREAM access specified on the instance of SQL Server. | |
FilestreamShareName | Gets the Windows share name where FILESTREAM data is stored on the instance of SQL Server. | |
FullTextService | Gets the Microsoft Search Full-Text service implementation for the instance of SQL Server. | |
HadrManagerStatus | Gets the status of the Hadr manager. | |
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 value that indicates whether the case is sensitive. | |
IsClustered | Gets the IsClustered property value. | |
IsFullTextInstalled | Gets the Boolean value that specifies whether Full-Text service is installed on the instance of SQL Server. | |
IsHadrEnabled | Gets a value that indicates whether the Hadr is enabled. | |
IsSingleUser | Gets the property value whether the user is single. | |
JobServer | Gets the SQL Server Agent associated with the instance of SQL Server. | |
Language | Gets the language of the server. | |
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. | |
Gets the Microsoft SQL Mail service associated with the instance of SQL Server. | ||
MailProfile | Gets or sets the mail profile of the server. | |
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 physical memory used by the server. | |
PhysicalMemoryUsageInKB | Gets an Int64 value that specifies the amount of memory in use by the instance of the Database Engine, in kilobytes. | |
Platform | Gets the server platform. | |
Processors | Gets the Processors property value. | |
ProcessorUsage | Gets an Int32 value that specifies the processor time used by the instance of the Database Engine. | |
Product | Gets the product of the server. | |
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 resource governor of the server. | |
ResourceLastUpdateDateTime | Gets the last time the resource was last updated. | |
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 | Represents a collection of ServerAuditSpecification objects. Each ServerAuditSpecification object represents a specific audit specification defined on the instance of SQL Server. | |
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 | Gets the service name for the server. | |
ServiceStartMode | Gets the start mode for the SQL Server service. | |
Settings | Gets modifiable settings for the instance of SQL Server. | |
SqlCharSet | Gets the value that identifies the character set used by the server. | |
SqlCharSetName | Gets the name of the character set used by the server. | |
SqlDomainGroup | Gets the domain group for the instance of SQL Server. | |
SqlSortOrder | Gets the SQL sort order from the collation. | |
SqlSortOrderName | Gets the name of the sort order used by the server. | |
State | Gets the state of the referenced object. (Inherited from SmoObjectBase.) | |
Status | Gets the current status of the Server. | |
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 | Gets the Boolean value that determines whether TCP/IP protocol is enabled on this instance of SQL Server. | |
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 major version of the server. | |
VersionMinor | Gets the VersionMinor property value. | |
VersionString | Gets the version string of the server. |
Top
Explicit Interface Implementations
Name | Description | |
---|---|---|
ISfcDomainLite.DomainInstanceName | Gets the instance name of the domain. | |
ISfcDomainLite.DomainName | Gets the domain name. | |
ISfcHasConnection.ConnectionContext | Gets the context for the connection represented by the current Server object. | |
ISfcSupportsDesignMode.IsDesignMode | Gets a Boolean value that specifies whether the Server supports design mode. |
Top