Server Properties

Public Properties

(see also Protected Properties )

	Name	Description
	ActiveDirectory	Gets information about the Active Directory settings for the instance of Microsoft SQL Server.
	BackupDevices	Represents a collection of BackupDevice objects. Each BackupDevice object represents a backup device defined on the instance of Microsoft SQL Server.
	Configuration	Gets the configuration options for the instance of Microsoft SQL Server.
	ConnectionContext	Gets the current server connection details for the instance of Microsoft SQL Server.
	Credentials	Represents a collection of Credential objects. Each Credential object represents a credential defined on the instance of Microsoft SQL Server.
	Databases	Represents a collection of Database objects. Each Database object represents a database defined on the instance of Microsoft SQL Server.
	DefaultTextMode	Gets or sets the Boolean property value that specifies whether the default text mode is set for the instance of SQL Server.
	Endpoints	Represents a collection of Endpoint objects. Each Endpoint object represents an endpoint defined on the instance of Microsoft SQL Server.
	Events	Gets the server events associated with the instance of Microsoft SQL Server.
	FullTextService	Gets the Microsoft Search full-text service implementation for the instance of Microsoft SQL Server.
	Information	Gets information about the instance of Microsoft SQL Server.
	InstanceName	Gets the instance name of the instance of Microsoft SQL Server.
	JobServer	Gets the SQL Server Agent associated with the instance of Microsoft SQL Server.
	Languages	Represents a collection of Language objects. Each Language object represents an languages supported by the instance of Microsoft SQL Server.
	LinkedServers	Represents a collection of LinkedServer objects. Each LinkedServer object represents a linked server registered on the instance of Microsoft SQL Server.
	Logins	Represents a collection of Login objects. Each Login object represents a login defined on the instance of Microsoft SQL Server.
	Mail	Gets the Microsoft SQL Mail service associated with the instance of Microsoft SQL Server.
	Name	Gets the name of the instance of Microsoft SQL Server.
	NotificationServices	Gets the Notification Services associated with the instance of Microsoft SQL Server.
	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 Microsoft SQL Server.
	ReplicationServer	Gets the Microsoft replication service associated with the instance of Microsoft SQL Server.
	Roles	Represents a collection of ServerRole objects. Each ServerRole object represents a role defined on the instance of Microsoft SQL Server.
	ServiceMasterKey	Gets the service master key associated with the instance of SQL Server.
	Settings	Gets modifiable settings for the instance of Microsoft SQL Server.
	State	Gets the state of the referenced object. (inherited from SmoObjectBase )
	SystemDataTypes	Represents a collection of SystemDataType objects. Each SystemDataType object represents a system data type defined on the instance of Microsoft SQL Server.
	SystemMessages	Represents a collection of SystemMessage objects. Each SystemMessage object represents a system message defined on the instance of Microsoft 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 Microsoft SQL Server.
	UserOptions	Gets the user options for the current connection to the instance of Microsoft SQL Server.

Protected Properties

	Name	Description
	ExecuteForScalar	Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (inherited from SqlSmoObject )
	ObjectInSpace	Gets the Boolean property value that specifies whether the object exists in isolation or whether it is connected to the instance of Microsoft SQL Server directly or indirectly. (inherited from SqlSmoObject )
	PresetProperties	Gets or sets the preset properties of the referenced object. (inherited from SqlSmoObject )
	ScalarResult	Gets the scalar result for the referenced object. (inherited from SqlSmoObject )

See Also

Reference

Server Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Connecting to an Instance of SQL Server
Disconnecting from an Instance of SQL Server
Managing Servers