Microsoft.SqlServer.Management.Smo.Wmi Namespace

The Microsoft.SqlServer.Management.Smo.Wmi namespace contains classes that provide programmatic access to the Windows Management Instrumentation (WMI) from an SMO application.

Updated text:17 July 2006

The Microsoft.SqlServer.Management.Smo.Wmi namespace contains all the classes that represent the SQL Server Windows Management Instrumentation. The classes in this namespace do not require a connection to an instance of SQL Server. The classes in this namespace control the SQL Server service and the SQL Server Agent service as represented by the Server class and the JobServer class. In effect, WMI is hierarchically above the SMO Server class. The WMI classes are also used to set the network protocols and libraries for client and server installations of SQL Server.

The Microsoft.SqlServer.Management.Smo.Wmi namespace resides in the Microsoft.SqlServer.Smo.dll assembly file. Also, some of the enumeration classes are in the Microsoft.SqlServer.WmiEnum.dll assembly file. You will have to import both files to access the classes in the Microsoft.SqlServer.Management.Smo.Wmi namespace.

By using the Microsoft.SqlServer.Management.Smo.Wmi namespace, you can do the following:

  • Stop, start, and pause both the instance of SQL Server and SQL Server Agent.

  • Set protocols, network libraries, and IP address information for SQL Server services and clients.

  • Manage SQL Server aliases.

Release

History

17 July 2006

Changed content:
  • Added text to the Remarks section.

Classes

Class Description
ClientProtocol The ClientProtocol class represents a network protocol installed on a client instance that allows communication with the instance of Microsoft SQL Server over a network.
ClientProtocolCollection The ClientProtocolCollection class represents a collection of ClientProtocol objects that represent all the client protocols defined on the parent object.
ClientProtocolProperty The ClientProtocolProperty class represents an attribute of a Windows Management Instrumentation (WMI) client protocol.
ClientProtocolPropertyCollection The ClientProtocolPropertyCollection class represents a collection of ClientProtocolProperty objects that represent all the attributes of the client protocol defined on the parent object.
IPAddressProperty The IPAddressProperty class represents an attribute of a Windows Management Instrumentation (WMI) IP address.
IPAddressPropertyCollection The IPAddressPropertyCollection class represents a collection of IPAddressProperty objects that represent all the attributes of the IP address defined on the parent object.
ManagedComputer The ManagedComputer class represents a Windows Management Instrumentation (WMI) installation on an instance of Microsoft SQL Server.
NetLibInfo The NetLibInfo object represents information regarding a network library file.
ProtocolBase The ProtocolBase class represents a protocol used on a Microsoft SQL Server client or a SQL Server server.
ProtocolProperty The ProtocolProperty class represents an attribute of a protocol on the Windows Management Instrumentation (WMI) installation.
ProtocolPropertyCollection The ProtocolPropertyCollection class represents a collection of ProtocolProperty objects that represent all the attributes of the protocol defined on the parent object.
ServerAlias The ServerAlias class represents an alias for a server connection on the Windows Management Instrumentation (WMI) installation.
ServerAliasCollection The ServerAliasCollection class represents a collection of ServerAlias objects that represent all the Microsoft SQL Server aliases defined on the parent object.
ServerInstance The ServerInstance class represents an instance of Microsoft SQL Server.
ServerInstanceCollection The ServerInstanceCollection class represents a collection of ServerInstance objects that represent all the instances of Microsoft SQL Server defined on the parent object.
ServerIPAddress The ServerIPAddress class represents the IP address of the server protocol defined on the Windows Management Instrumentation (WMI) installation.
ServerIPAddressCollection The ServerIPAddressCollection class represents a collection of ServerIPAddress objects that represent all the server IP addresses defined on the parent object.
ServerProtocol The ServerProtocol class represents a network protocol installed on a server instance that allows communication with Microsoft SQL Server clients over a network.
ServerProtocolCollection The ServerProtocolCollection class represents a collection of ServerProtocol objects that represent all the server protocols defined on the parent object.
ServerProtocolProperty The ServerProtocolProperty class represents an attribute of a Windows Management Instrumentation (WMI) server protocol.
ServerProtocolPropertyCollection The ServerProtocolPropertyCollection class represents a collection of ServerProtocolProperty objects that represent all the attributes of the server protocol defined on the parent object.
Service The Service class represents an instance of the SQL Server service.
ServiceCollection The ServiceCollection class represents a collection of Service objects that represent all SQL Server services defined on the parent object.
WmiCollectionBase The WmiCollectionBase class represents all collection objects in the Windows Management Instrumentation (WMI) object reference.
WmiConnectionInfo The WmiConnectionInfo class represents connection information used by the installation of Windows Management Instrumentation (WMI).
WmiSmoObject The WmiSmoObject class represents the fundamental Windows Management Instrumentation (WMI) object from which all WMI objects are constructed.

Enumerations

Enumeration Description
ManagedServiceType The ManagedServiceType enumeration contains values that are used to specify the types of service that can be managed with Windows Management Instrumentation (WMI).
PropertyType The PropertyType enumeration contains values that are used to specify the data type of property for any of the Windows Management Instrumentation (WMI) property objects.
ProviderArchitecture The ProviderArchitecture enumeration contains values that are used to specify the Windows Management Instrumentation (WMI) provider architecture.
ServiceErrorControl The ServiceErrorControl enumeration contains values that are used to specify the severity of the error if the SQL Server service fails to start during startup.
ServiceStartMode The ServiceStartMode enumeration contains values that are used to specify the method used to start the SQL Server service.
ServiceState The ServiceState enumeration contains values that are used to specify the status of the SQL Server service.