InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 10:25:06 GMT20http://www.sqlservercentral.com/Forums/Topic572280-8-1.aspx[quote][b]sumit kende (9/19/2008)[/b][hr]How to use sqlcmd utility with blank password. sa user having blank password. Following code gives error :=> Sqlcmd: '-P': Missing argument. Enter '-?' for help. I tried with console application in .net 2008static void Main(string[] args) { string fileName = @"C:\Createtable.sql"; ProcessStartInfo info = new ProcessStartInfo("sqlcmd", @" -S DEV023\SQL2K -U sa -d pubs -o C:\sqlout.txt -i """ + @fileName + @""" -P"); info.UseShellExecute = false; info.CreateNoWindow = true; info.WindowStyle = ProcessWindowStyle.Hidden; info.RedirectStandardOutput = true; Process p = new Process(); p.StartInfo = info; p.Start();}[/quote]Only way to do it is with a "trusted connection". I don't have the precise syntax, but I'll just bet it's in Books Online.Fri, 19 Sep 2008 20:58:54 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic572280-8-1.aspxHow to use sqlcmd utility with blank password. sa user having blank password. Following code gives error :=> Sqlcmd: '-P': Missing argument. Enter '-?' for help. I tried with console application in .net 2008static void Main(string[] args) { string fileName = @"C:\Createtable.sql"; ProcessStartInfo info = new ProcessStartInfo("sqlcmd", @" -S DEV023\SQL2K -U sa -d pubs -o C:\sqlout.txt -i """ + @fileName + @""" -P"); info.UseShellExecute = false; info.CreateNoWindow = true; info.WindowStyle = ProcessWindowStyle.Hidden; info.RedirectStandardOutput = true; Process p = new Process(); p.StartInfo = info; p.Start();}Fri, 19 Sep 2008 00:10:54 GMTsumit kende