To use DMO from VB, follow these simple rules:

  • Include the SQL DMO type library
  • Create a SQL Server object
  • Connect the SQL Server object to SQL Server
  • Use the SQL Server objects
  • Disconnect from SQL Server