InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 13:18:18 GMT20http://www.sqlservercentral.com/Forums/Topic928826-146-1.aspxCan you supply the servername and the instance name if it is not the default instance on the server. This will help us format the SQLCMD parameters you should be using.Generally when I have used it is has been:sqlcmd -H<Host name if on different machine> -S<SQL server name\instance name> -U<username if needed> -P<password> -E -i<input file for execution> -o<output file for results>Mon, 23 Aug 2010 02:18:02 GMTBravehearT1326http://www.sqlservercentral.com/Forums/Topic928826-146-1.aspxTrysqlcmd -Sservername\instancename:cool:Mon, 23 Aug 2010 01:45:05 GMTJamie Ingram-729524http://www.sqlservercentral.com/Forums/Topic928826-146-1.aspxIt does not work...Maybe it's because i have my default instance in SQL Server 2005 and my named instance in SQL Server 2000.Maybe i have to change the order as the instances are installed and put the default instance as SQL Server 2000.What do you think?I can connect to SQL Server 2005 using oSQL instead of sqlcmd, isn't this strange?Fri, 28 May 2010 01:08:14 GMTriver1http://www.sqlservercentral.com/Forums/Topic928826-146-1.aspxUse--> sqlcmd -Sservernamehttp://syntaxhelp.com/SQLServer/SQLCMDThu, 27 May 2010 13:02:01 GMTMANU-J.http://www.sqlservercentral.com/Forums/Topic928826-146-1.aspxIt as any thing to do with the fact that i have a SQL Server 2000 named instance on the same box?I can connect using osql, but can not connect using sqlcmd...osql was finished in SQL Server 2005, correct?Thu, 27 May 2010 03:49:46 GMTriver1http://www.sqlservercentral.com/Forums/Topic928826-146-1.aspxHi, i try to execute this command at the cmd level:sqlcmd -S computernamei receive the following error:invalid comand line arg[2]: '-S'My instance name the name of my computer.Why does this fails?Thu, 27 May 2010 03:11:13 GMTriver1