How can we use this stuff?
The text book answer would be "The SQL-DMO allows you to create custom
management applications for SQL Server and MSDE".
It is really up to you on how you decide to use the SQL-DMO. I use it to modify
stored procedures, execute jobs and DTS packages, and view system information
for clients who have chosen to run the MSDE or SQL Server as their web server
database. Since I can not visit each site every time a client has a problem,
I have developed a set of ASP scripts that are loaded on their web servers that
enable me to monitor and administer their databases.
I hope this article and sample code will produce a few more uses for this
powerful feature.