SQL Distributed Management Objects

25 Oct 2001 | by | Filed in
Page 3 of 5
  1. Overview
  2. What is SQL-DMO?
  3. How can we use this stuff?
  4. The sample application
  5. Summary

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.

You might also like...

Comments

SQL tutorials

SQL books

SQL forum discussion

SQL podcasts

  • Deep Fried Bytes: What is the Big Deal about Big Data?

    Published 8 years ago, running time 0h39m

    In this episode, Woody sits down with Andrew Brust to discuss another “big” technology for developers and IT professionals: Big Data. Woody and Andrew talk about what Big Data is, who is using it, what tools are available and finally how we has technologists can use this for our products and serv.

SQL jobs

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Web Development

Developer Jobs

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

Cancel
“Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.” - Brian Kernighan