且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何以编程方式更改SQL Server 2005 Express Edition配置

更新时间:2023-02-02 13:16:17

SQL Server管理对象(SMO)是为以下目的而设计的对象的集合对管理Microsoft SQL Server的所有方面进行编程.参考: http://msdn.microsoft.com/en-us/library/ms162169.aspx [ ^ ]
SQL Server Management Objects (SMO) is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server. Reference at: http://msdn.microsoft.com/en-us/library/ms162169.aspx[^]


private void button1_Click(object sender, EventArgs e)
        {
            Process p = new Process();
            ProcessStartInfo psi = new ProcessStartInfo();
            psi.FileName = Application.StartupPath.Trim() + @"\SqlServer2005 Express\SQLEXPR.EXE";
            //-q[n|b|r|f]   Sets user interface (UI) level:
            //n = no UI
            //b = basic UI (progress only, no prompts)
            //r = reduced UI (dialog at the end of installation)
            //f = full UI
            psi.Arguments = "/qb username=\"sa\" companyname=\"Rumtek\" addlocal=ALL  disablenetworkprotocols=\"0\" instancename=\"SQLExpress\" SECURITYMODE=\"SQL\" SAPWD=\"lock\"";
            p.StartInfo = psi;
            p.Start();
        }


private void button2_Click(object sender, EventArgs e)
        {
            //Registry.SetValue(@"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQLServer\SuperSocketNetLib\Tcp\IPAll", "TcpPort", "1433");
            Registry.SetValue(@"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib\Tcp\IPAll", "TcpPort", "1433");
            Process p = new Process();
            ProcessStartInfo psi = new ProcessStartInfo();
            psi.FileName = Application.StartupPath.Trim() + @"\command\cmd.exe";
            psi.Arguments = "NET STOP MSSQL


SQLExpress"; p.StartInfo = psi; p.Start(); 进程p1 = new Process(); ProcessStartInfo psi1 =新的ProcessStartInfo(); psi1.FileName = Application.StartupPath.Trim()+ @"\ command \ cmd.exe"; psi1.Arguments ="NET START MSSQL
SQLExpress"; p.StartInfo = psi; p.Start(); Process p1 = new Process(); ProcessStartInfo psi1 = new ProcessStartInfo(); psi1.FileName = Application.StartupPath.Trim() + @"\command\cmd.exe"; psi1.Arguments = "NET START MSSQL