My past two columns provided the techniques you need to programmatically manage SQL Server databases with SQL Distributed Management Objects (SQL-DMO). These techniques are particularly important for Microsoft Access developers and others. Enterprise Manager doesn't ship with the Microsoft Data Engine (MSDE) or the Microsoft SQL Server 2000 Desktop Engine. MSDE 2000 ships with Microsoft Office XP (formerly codenamed Office 10), and MSDE ships with Office 2000. However, SQL-DMO lets you selectively incorporate Enterprise Manager funtionality in your solutions.

In ...