How to register SQL-DMO at client side dynamically using .net SetUp file.

Package SQL-DMO files individually

1. Start Microsoft Visual Studio .NET.

2. Create a new Setup project:

   1. On the File menu, point to New, and then click Project.

      1. The New Project dialog box appears.

   2. Under Project Types, click Setup and Deployment Projects.

   3. Under Templates, click Setup Project.

   4. 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

• 1. The following table lists each file name and its default location:

1. Change value of the Register property of the Sqldmo.dll file to vsdrfCOMSelfReg:

   1. In Solution Explorer, click sqldmo.dll.

   2. In the Properties window, click vsdrfCOMSelfReg in the Register list.

2. 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.

• 1. In Solution Explorer, click your Setup project

  2. On the View menu, point to Editor, and then click File System.

  3. On the Action menu, point to Add Special Folder, and then click System Folder.

  4. In Solution Explorer, click sqlunirl.dll.

  5. In the Properties window, click System Folder in the Folder list.

3. On the Build menu, click Build Project Name to build your Setup project.

-Courtesy http://support.microsoft.com/kb/326613