Export (0) Print
Expand All

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.

ClassDescription
ClientProtocolThe ClientProtocol class represents a network protocol installed on a client instance that allows communication with the instance of Microsoft SQL Server over a network.
ClientProtocolCollectionThe ClientProtocolCollection class represents a collection of ClientProtocol objects that represent all the client protocols defined on the parent object.
ClientProtocolPropertyThe ClientProtocolProperty class represents an attribute of a Windows Management Instrumentation (WMI) client protocol.
ClientProtocolPropertyCollectionThe ClientProtocolPropertyCollection class represents a collection of ClientProtocolProperty objects that represent all the attributes of the client protocol defined on the parent object.
IPAddressPropertyThe IPAddressProperty class represents an attribute of a Windows Management Instrumentation (WMI) IP address.
IPAddressPropertyCollectionThe IPAddressPropertyCollection class represents a collection of IPAddressProperty objects that represent all the attributes of the IP address defined on the parent object.
ManagedComputerThe ManagedComputer class represents a Windows Management Instrumentation (WMI) installation on an instance of Microsoft SQL Server.
NetLibInfoThe NetLibInfo object represents information regarding a network library file.
ProtocolBaseThe ProtocolBase class represents a protocol used on a Microsoft SQL Server client or a SQL Server server.
ProtocolPropertyThe ProtocolProperty class represents an attribute of a protocol on the Windows Management Instrumentation (WMI) installation.
ProtocolPropertyCollectionThe ProtocolPropertyCollection class represents a collection of ProtocolProperty objects that represent all the attributes of the protocol defined on the parent object.
ServerAliasThe ServerAlias class represents an alias for a server connection on the Windows Management Instrumentation (WMI) installation.
ServerAliasCollectionThe ServerAliasCollection class represents a collection of ServerAlias objects that represent all the Microsoft SQL Server aliases defined on the parent object.
ServerInstanceThe ServerInstance class represents an instance of Microsoft SQL Server.
ServerInstanceCollectionThe ServerInstanceCollection class represents a collection of ServerInstance objects that represent all the instances of Microsoft SQL Server defined on the parent object.
ServerIPAddressThe ServerIPAddress class represents the IP address of the server protocol defined on the Windows Management Instrumentation (WMI) installation.
ServerIPAddressCollectionThe ServerIPAddressCollection class represents a collection of ServerIPAddress objects that represent all the server IP addresses defined on the parent object.
ServerProtocolThe ServerProtocol class represents a network protocol installed on a server instance that allows communication with Microsoft SQL Server clients over a network.
ServerProtocolCollectionThe ServerProtocolCollection class represents a collection of ServerProtocol objects that represent all the server protocols defined on the parent object.
ServerProtocolPropertyThe ServerProtocolProperty class represents an attribute of a Windows Management Instrumentation (WMI) server protocol.
ServerProtocolPropertyCollectionThe ServerProtocolPropertyCollection class represents a collection of ServerProtocolProperty objects that represent all the attributes of the server protocol defined on the parent object.
ServiceThe Service class represents an instance of the SQL Server service.
ServiceCollectionThe ServiceCollection class represents a collection of Service objects that represent all SQL Server services defined on the parent object.
WmiCollectionBaseThe WmiCollectionBase class represents all collection objects in the Windows Management Instrumentation (WMI) object reference.
WmiConnectionInfoThe WmiConnectionInfo class represents connection information used by the installation of Windows Management Instrumentation (WMI).
WmiSmoObjectThe WmiSmoObject class represents the fundamental Windows Management Instrumentation (WMI) object from which all WMI objects are constructed.

EnumerationDescription
ManagedServiceTypeThe ManagedServiceType enumeration contains values that are used to specify the types of service that can be managed with Windows Management Instrumentation (WMI).
PropertyTypeThe PropertyType enumeration contains values that are used to specify the data type of property for any of the Windows Management Instrumentation (WMI) property objects.
ProviderArchitectureThe ProviderArchitecture enumeration contains values that are used to specify the Windows Management Instrumentation (WMI) provider architecture.
ServiceErrorControlThe ServiceErrorControl enumeration contains values that are used to specify the severity of the error if the SQL Server service fails to start during startup.
ServiceStartModeThe ServiceStartMode enumeration contains values that are used to specify the method used to start the SQL Server service.
ServiceStateThe ServiceState enumeration contains values that are used to specify the status of the SQL Server service.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft