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.

Classes

ClientProtocol

The ClientProtocol class represents a network protocol installed on a client instance that allows communication with the instance of 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 MicrosoftSQL Server.

NetLibInfo

The NetLibInfo object represents information regarding a network library file.

ProtocolBase

The ProtocolBase class represents a protocol used on a SQL Server client or a server that is running SQL 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 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 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 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.

Enums

ProviderArchitecture

The ProviderArchitecture enumeration contains values that are used to specify the Windows Management Instrumentation (WMI) provider architecture.

Remarks

The Microsoft.SqlServer.Management.Smo.Wmi namespace contains all the classes that represent the SQL Server WMI. 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. 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.

Note

You must register the Microsoft.SqlServer.SqlWmiManagment.dll by using regasm.exe before you can use the Microsoft.SqlServer.Management.Smo.Wmi classes.