Export (0) Print
Expand All

Server Properties

(see also Protected Properties )
  Name Description
ms220267.pubproperty(en-US,SQL.90).gif ActiveDirectory
Gets information about the Active Directory settings for the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif BackupDevices
Represents a collection of BackupDevice objects. Each BackupDevice object represents a backup device defined on the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif Configuration
Gets the configuration options for the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif ConnectionContext
Gets the current server connection details for the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif Credentials
Represents a collection of Credential objects. Each Credential object represents a credential defined on the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif Databases
Represents a collection of Database objects. Each Database object represents a database defined on the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).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(en-US,SQL.90).gif Endpoints
Represents a collection of Endpoint objects. Each Endpoint object represents an endpoint defined on the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif Events
Gets the server events associated with the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif FullTextService
Gets the Microsoft Search full-text service implementation for the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif Information
Gets information about the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif InstanceName
Gets the instance name of the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif JobServer
Gets the SQL Server Agent associated with the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif Languages
Represents a collection of Language objects. Each Language object represents an languages supported by the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif LinkedServers
Represents a collection of LinkedServer objects. Each LinkedServer object represents a linked server registered on the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif Logins
Represents a collection of Login objects. Each Login object represents a login defined on the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif Mail
Gets the Microsoft SQL Mail service associated with the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif Name
Gets the name of the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif NotificationServices
Gets the Notification Services associated with the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif Properties 
Gets a collection of Property objects that represent the object properties.
(inherited from SqlSmoObject )
ms220267.pubproperty(en-US,SQL.90).gif ProxyAccount
Gets the proxy account associated with the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif ReplicationServer
Gets the Microsoft replication service associated with the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif Roles
Represents a collection of ServerRole objects. Each ServerRole object represents a role defined on the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif ServiceMasterKey
Gets the service master key associated with the instance of SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif Settings
Gets modifiable settings for the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif State 
Gets the state of the referenced object.
(inherited from SmoObjectBase )
ms220267.pubproperty(en-US,SQL.90).gif SystemDataTypes
Represents a collection of SystemDataType objects. Each SystemDataType object represents a system data type defined on the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif SystemMessages
Represents a collection of SystemMessage objects. Each SystemMessage object represents a system message defined on the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).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(en-US,SQL.90).gif Urn 
Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.
(inherited from SqlSmoObject )
ms220267.pubproperty(en-US,SQL.90).gif UserData 
Gets or sets user-defined data associated with the referenced object.
(inherited from SmoObjectBase )
ms220267.pubproperty(en-US,SQL.90).gif UserDefinedMessages
Represents a collection of UserDefinedMessage objects. Each UserDefinedMessage object represents a user-defined message defined on the instance of Microsoft SQL Server.
ms220267.pubproperty(en-US,SQL.90).gif UserOptions
Gets the user options for the current connection to the instance of Microsoft SQL Server.

  Name Description
ms220267.protproperty(en-US,SQL.90).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(en-US,SQL.90).gif 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 )
ms220267.protproperty(en-US,SQL.90).gif PresetProperties 
Gets or sets the preset properties of the referenced object.
(inherited from SqlSmoObject )
ms220267.protproperty(en-US,SQL.90).gif ScalarResult 
Gets the scalar result for the referenced object.
(inherited from SqlSmoObject )

Community Additions

ADD
Show:
© 2014 Microsoft