O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required