






Home-grown Data Mining in SQL Server
s a database programmer, when you don’t know where the tables and columns you need to do your job are, you’re dead in the water. You can browse through Enterprise
s a database programmer, when you don’t know where the tables and columns you need to do your job are, you’re dead in the water. You can browse through Enterprise
‘ Get an array with the name of an application’s roles’ Note: requires a reference to the COM+ Admin Type Library” Example:’ Dim roles() As String = GetComPlusAppRoles(“System Application”, “”)’
‘ Get an array with the members of an application’s role’ Note: requires a reference to the COM+ Admin Type Library” Example:’ Dim members() As String = GetComPlusAppRoleMembers(“System Application”,’ “Administrator”,
‘ Shut-down the COM+ application with the input name’ Note: requires a reference to the COM+ Admin Type Library” Example: ShutDownComPlusApplication(“MyComPlusApp”, “”)Sub ShutDownComPlusApplication(ByVal applicationName As String, _ ByVal serverName As
‘ Export the COM+ application with the input name to a MSI installer file’ Note: requires a reference to the COM+ Admin Type Library” Example: ExportComPlusApplication(“MyComPlusApp”, “C:MyComPlusApp.msi”, “”)Sub ExportComPlusApplication(ByVal applicationName
‘ Start the COM+ application with the input name’ Note: requires a reference to the COM+ Admin Type Library” Example: StartComPlusApplication(“MyComPlusApp”, “”)Sub StartComPlusApplication(ByVal applicationName As String, _ ByVal serverName As