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

Creating Applications with SQL-DMO

You can use SQL-DMO using Transact SQL, in Active Server Pages or build entire applications around SQL-DMO. To build a SQL-DMO application or component requires a 32-bit programming language that can create OLE controller applications. Tools such as Microsoft Visual C++, a Windows-based Java tool, or Microsoft Excel for Windows NT with 32-bit VBA (Visual Basic for Applications) can easily be used. The examples and code samples shown in this chapter are based on Microsoft Visual Basic 6.0. The choice of Visual Basic is easy because it is the most popular and rapid application-development tool available. The core language of Visual Basic 6.0 is VBA and can be found in Office 2000 (that is, Access, Word, PowerPoint, ...

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