DDL_PROCEDURE_EVENTS, ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER, c# samples

Class | Childs (3) | Methods | Properties (13) | Qualifiers (1) | Instances | Namespaces (1)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

c# Code samples

The class DDL_PROCEDURE_EVENTS is abstract and serves only as a base for new classes. You cannot create instances of abstract class, see derived classes.

WMI query - sample windows WQL with C#, ComputerName property of DDL_PROCEDURE_EVENTS

Short C# sample code to get the abstract class DDL_PROCEDURE_EVENTS and its properties.
See in another language: VBScript, VB.Net.
	//https://wutils.com/wmi/
	
	//Project -> Add reference -> System.Management
	//using System.Management;
	
	//set the class name and namespace
	string NamespacePath = "\\\\.\\ROOT\\Microsoft\\SqlServer\\ServerEvents\\MSSQLSERVER";
	string ClassName = "DDL_PROCEDURE_EVENTS";
	
	//Create ManagementClass
	ManagementClass mClass = new ManagementClass(NamespacePath + ":" + ClassName);
	
	// List the properties in the DDL_PROCEDURE_EVENTS class
	PropertyDataCollection lproperties = mClass.Properties;
	
	// display the properties  
	Console.WriteLine(string.Format("Property Names in {0}: ",ClassName));
	foreach (PropertyData property in lproperties)
	{
	    Console.WriteLine("name: {0}, Origin: {1}", property.Name, property.Origin );
	}	
	

WMI query - list of class instances

List of all instances of DDL_PROCEDURE_EVENTS class in C#.
See in another language: VBScript, VB.Net.
	//https://wutils.com/wmi/
	
	//Project -> Add reference -> System.Management
	//using System.Management;
	
	//set the class name and namespace
	string NamespacePath = "\\\\.\\ROOT\\Microsoft\\SqlServer\\ServerEvents\\MSSQLSERVER";
	string ClassName = "DDL_PROCEDURE_EVENTS";
	
	//Create ManagementClass
	ManagementClass oClass = new ManagementClass(NamespacePath + ":" + ClassName);
	
	//Get all instances of the class and enumerate them
	foreach (ManagementObject oObject in oClass.GetInstances())
	{
		//access a property of the Management object
		Console.WriteLine("ComputerName : {0}", oObject["ComputerName"]);
	}
	
comments powered by Disqus
WUtils.com