Chapter 26. Using SQL-DMO

by Mark Spenik

IN THIS CHAPTER

  • SQL Server's Object Model

  • Why Use SQL-DMO?

  • Creating Applications with SQL-DMO

  • Enhancing the SQL Server DBA Assistant

  • Using SQL-DMO with Stored Procedures

  • SQL-DMO FAQ

Have you ever felt that Microsoft left out a utility or some graphical display that you thought would really make your life easier? With SQL Server 2000, you might be able to write that utility yourself! “How?” you ask. The answer is an exciting feature added first to SQL Server 6.0 and extended with SQL Server 2000—SQL-DMO!

SQL-DMO stands for SQL Distributed Management Objects. SQL-DMO is based on Microsoft's Component Object Model (COM) and supports OLE automation. OLE stands for object linking and embedding, but in the past few ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.