更新时间: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