sqldmo（分布式管理对象）.doc

sqldmo（分布式管理对象） SQLDMO registration method: 1, including files and routing Filename location Sqldmo.dll, c:\Program, Files\Microsoft, SQL, Server\80\Tools\Binn Sqlresld.dll executable directory Sqlsvc.dll executable directory W95scm.dll, Installation, drive:\Program, Files\Microsoft, SQL, Server\80\Tools\Binn Sqlsvc.rll executable directory \resources\2052 Sqldmo.rll, c:\Program, Files\Microsoft, SQL, Server\80\Tools\Binn\Resources\1033 Sqlunirl.dll c:\windows\system32 2, execute the DOS command RegSvr32 sqldmo.dll ------------------------------------------------------------------------------ Its been a long day since I signed up for sqldmo so that everyone can save time after registering for sqldmo! The results are as follows: To build a project, the code is as follows: (direct copy can be) Using System; Using System.Collections.Generic; Using System.ComponentModel; Using System.Data; Using System.Drawing; Using System.Text; Using System.Windows.Forms; Using System.IO; Using System.Diagnostics; Namespace deployment demo { Public, partial, class, Form1: Form { Public, Form1 () { InitializeComponent (); } Public void DeploySQLDMO (string dllPath) { String systemPath = Environment.GetFolderPath (Environment.SpecialFolder.System); String sqlwoaFile = String.Format (@ {0}\sqlwoa.dll , systemPath); String sqlwidFile = String.Format (@ {0}\sqlwid.dll , systemPath); If (... File.Exists (sqlwoaFile)) { File.Copy (String.Format (@ {0}\sqlwoa.dll , dllPath), sqlwoaFile); } If (... File.Exists (sqlwidFile)) { File.Copy (String.Format (@ {0}\sqlwid.dll , dllPath), sqlwidFile); } Process P = new, Process (); P.StartInfo.FileName = regsvr32.exe; P.StartInfo.Arguments = String.Format (/s {0}\\sqldmo.dll, dllPath); P.StartInfo.WorkingDirectory = systemPath; P.StartInfo.WindowStyle = ProcessWindowStyle.Hidden; P.Start (); P.WaitForExit (); P.Close (); } Private, void, Form1_Load (object, sender, EventArgs, e) { DeploySQLDMO (D:\\SQLDMO); } } } Note: in the dllPath folder must includ