public static string ExeCommand(string commandText) { Process p = new Process(); p.StartInfo.FileName = "cmd.exe"; p.StartInfo.UseShellExecute = false; p.StartInfo.RedirectStandardInput = true; p.StartInfo.RedirectStandardOutput = true; p.StartInfo.RedirectStandardError = true; p.StartInfo.CreateNoWindow = true; string strOutput = null; try { p.Start(); p.StandardInput.WriteLine(commandText); p.StandardInput.WriteLine("exit"); strOutput = p.StandardOutput.ReadToEnd(); p.WaitForExit(); p.Close(); } catch (Exception e) { strOutput = e.Message; } return strOutput; }

protected void Button1_Click(object sender, EventArgs e) { string sqlQuery = "sqlcmd.exe -U sa -P 123 -S 20100330-0922 -d test -i c:\\1.sql"; string strRst = ExeCommand(sqlQuery); }

use master go CREATE ENDPOINT Orders_Endpoint6 state=started as http( path='/sql/orders6', AUTHENTICATION=(INTEGRATED), ports=(clear) ) for soap( WebMethod 'CustOrdersOrders'( name='test.dbo.GetAlltb12' ), wsdl=default, database='test', namespace='http://mysite.org/' )