All required SQL-DMO components are installed as part of either a Microsoft® SQL Server™ server or client installation. SQL-DMO is implemented in a single dynamic-link library (DLL). You may develop SQL-DMO applications on either a client or a server. When using an OLE Automation controller as a development platform, such as Microsoft Visual Basic®, no additional files are required. Application development using C or C++ requires the SQL-DMO header files.
SQL-DMO sample applications, providing additional reference material for SQL-DMO application development, are included with SQL Server.
| Directory | File | Description |
|---|---|---|
| \Mssql7\Binn | Sqldmo.dll | DLL implementing SQL-DMO objects. |
| \Mssql7\Binn\ Resources\xxxx |
Sqldmo.rll | Localized resource file. The resource directory varies based on the national language of the installed SQL Server client or server. For example, the directory 1033 is a decimal representation of the language identifier 0X0409, indicating English, U.S. |
| Sqldmo.hlp | SQL-DMO help file used within the development environment to provide context sensitive help about SQL-DMO objects, properties and methods. | |
| \Mssql7\ Devtools\Include |
Sqldmo.h | C/C++ header file containing SQL-DMO member function prototypes, enumerated data types, and macros. |
| Sqldmoid.h | C/C++ header file containing SQL-DMO interface and class identifiers. | |
| \Mssql7\Install | Sqldmo.sql | Transact-SQL script implementing stored procedures that support SQL-DMO. Installed on server installation only. |
| \Mssql7\ Devtools\Samples\ Sqldmo |
ALL | Sample applications illustrating SQL-DMO use. |
Overview of Installing SQL Server