Delen via

  • Artikel

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.

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

In SQL Server 2008, you must register the Microsoft.SqlServer.SqlWmiManagment.dll by using regasm.exe before you can use the Microsoft.SqlServer.Management.Smo.Wmi classes.

Classes

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

Enumerations

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