Enhancing the SQL Server DBA Assistant

Now comes the real value. As you probably know by now, examples that use SQL-DMO are hard to find. SQL Server ships with a few SQL-DMO samples that are poorly documented. The overall SQL-DMO documentation contains very few descriptive examples but concentrates on describing the objects and methods.

On the Web site for this book is a Visual Basic project titled samsdba2000.vbp, which is the Visual Basic project file and contains all the source code for the application SQL Server DBA Assistant. The source code is included as a foundation that you can modify and enhance to meet your own needs. The following sections discuss the most important parts of the SQL Server DBA Assistant.


The source code for the ...

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.