SQL-DMO
SQL-DMO is a collection of objects that helps you to manage SQL Server programmatically. SQL-DMO is a dual interface, in-process Component Object Model (COM) server that is implemented as a DLL. When you create a SQL-DMO application, you can use any OLE Automation controller or any COM client development operating system that uses C or C++.
SQL-DMO components
SQL-DMO includes the following files:
| File Name | Description |
|---|
| Sqldmo.dll | DLL that implements SQL-DMO objects |
| Sqldmo.rll | DMO resource file |
| Sqlresld.dll | SQL Enterprise Manager resource DLL loader |
| Sqlsvc.dll | Database service layer |
| Sqlsvc.rll | Database service layer resource DLL |
| Sqlunirl.dll | SQL Server Unicode/ANSI translation layer |
| W95scm.dll | SQL Service Control Manager abstraction layer |
Package SQL-DMO files individually
| 1. | Start Microsoft Visual Studio .NET. |
| 2. | Create a new Setup project: | a. | On the File menu, point to New, and then click Project.
The New Project dialog box appears. | | b. | Under Project Types, click Setup and Deployment Projects. | | c. | Under Templates, click Setup Project. | | d. | Click OK. |
|
| 3. | Add the following files to your Setup project: | • | Sqldmo.dll | | • | Sqldmo.rll | | • | Sqlresld.dll | | • | Sqlsvc.dll | | • | Sqlsvc.rll | | • | Sqlunirl.dll | | • | W95scm.dll |
The following table lists each file name and its default location: | File Name | Location |
|---|
Sqldmo.dll
Sqlresld.dll
Sqlsvc.dll
W95scm.dll | Installation drive:\Program Files\Microsoft SQL Server\80\Tools\Binn | Sqlsvc.rll
Sqldmo.rll | Installation drive:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033 | | Sqlunirl.dll | Installation drive:\WINNT\system32 |
|
| 4. | Change value of the Register property of the Sqldmo.dll file to vsdrfCOMSelfReg: | a. | In Solution Explorer, click sqldmo.dll. | | b. | In the Properties window, click vsdrfCOMSelfReg in the Register list. |
|
| 5. | Change the installation folder of the Sqlunirl.dll file to the system folder. For example, change the installation folder to the Installation drive:\Winnt\System32 folder or to the Installation drive:\Windows\System folder. | a. | In Solution Explorer, click your Setup project | | b. | On the View menu, point to Editor, and then click File System. | | c. | On the Action menu, point to Add Special Folder, and then click System Folder. | | d. | In Solution Explorer, click sqlunirl.dll. | | e. | In the Properties window, click System Folder in the Folder list. |
|
| 6. | On the Build menu, click Build Project Name to build your Setup project. |
Reference : http://support.microsoft.com/Default.aspx?kbid=326613
Comments