Do we require to install SSMS to run SQL Script in command Prompt.

• ajanur.becs

  SSC Journeyman

  Points: 77

  More actions

  November 5, 2014 at 1:56 am

  #312237

  I tried to install SQL Server 2008 Native Client and I am not able to run the SQL script using command Line. I am getting an error "SQL type is not recognized..." So My questions is here.. is there any special package is there to run Command Line Utility without installing any SQL Client?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 5, 2014 at 3:34 am

  #1756693

  I suppose you're thinking of the sqlcmd utility.

  It doesn't come with the native client installation.

  It is installed with the client tools and with the database engine setup.

  You can also dowload it directly from here

  -- Gianluca Sartori

• patricklambin

  SSCrazy Eights

  Points: 9994

  More actions

  November 28, 2014 at 11:15 am

  #1761475

  for the SQLCMD for SQL Server 2008 ( version 10 ) , you could try

  or try this link :

  http://www.microsoft.com/en-us/download/details.aspx?id=27596

  Be careful , I am thinking that the support is ended for SQL Server 2008 RTM. Maybe not for SQL Server 2008 SP3

  Have a nice day

• patricklambin

  SSCrazy Eights

  Points: 9994

  More actions

  November 28, 2014 at 11:23 am

  #1761476

  For the support of SQL Server 2008 , I would suggest you to have a look at

  http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/07/09/end-of-mainstream-support-for-sql-server-2008-and-sql-server-2008-r2.aspx

  Have a nice day