Library tutorials & articles
SQL Distributed Management Objects
- Overview
- What is SQL-DMO?
- How can we use this stuff?
- The sample application
- 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.
Related articles
Related discussion
-
how to find second largest number through a query in sql
by om_java2009 (29 replies)
-
High-Performance .NET Application Development & Architecture
by Manjot Bawa (0 replies)
-
Help with query and loop
by sara87 (2 replies)
-
Permutations and combinations of multiple return codes
by actuszeus (1 replies)
-
help needed on tree level sql?
by kareen (0 replies)
Related podcasts
-
Stack Overflow: Podcast #28
This is the twenty-eighth episode of the StackOverflow podcast, where Joel and Jeff discuss Windows Azure, SQL Server 2008 full text search, Bayesian filtering, porn detection, and project management — among other things. Jeff met the inestimable Joey DeVilla aka Accordion Guy...
I read your article and it is indeed an informative one. However I am having some serious problems creating a Job Schedule in VB.NET. I have managed to reduce the number of errors in the properties of the JobSchedule Object but I am still experiencing some difficulty...
You said you would help with any questions soI appeal to you for help!!
Regards,
Liselle
Thank you for this article I didn't know about DMO before,it was really important to me, I had the same problem I am working on a project and I have to give and solve problems from time to time , please write more about DMO
This thread is for discussions of SQL Distributed Management Objects.