Help with script

• rbarrera

  Mr or Mrs. 500

  Points: 575

  More actions

  July 9, 2008 at 11:33 am

  #184487

  Can someone help me with this script? I'm missing a quote, comma, or parenthesis somewhere. My instancename has been replaced with (INSTANCENAME) to protect the innocent. Thanks.....Here's the script:

  ECHO ON

  @ECHO OFF

  FOR /F "TOKENS=6 DELIMS= " %%A IN ('"%ProgramFiles%\Microsoft SQL Server\90\Tools\Binn\SQLCMD" -S "127.0.0.1\(INSTANCENAME)" -Q "SELECT @@VERSION"^| FINDSTR /I "SQL SERVER"') DO (SET SQLBUILD=%%A)

  ECHO %SQLBUILD%

  @ECHO OFF

  PAUSE

• rbarrera

  Mr or Mrs. 500

  Points: 575

  More actions

  July 9, 2008 at 1:07 pm

  #840468

  Thanks ME, I figured it out :p

  ECHO ON

  SET WORKINGDIRECTORY=%CD%

  ECHO %WORKINGDIRECTORY%

  CD %ProgramFiles%\Microsoft SQL Server\90\Tools\Binn

  @ECHO OFF

  FOR /F "TOKENS=6 DELIMS= " %%A IN ('SQLCMD.EXE -S "127.0.0.1\(myinstance)" -Q "SELECT @@VERSION"^| FINDSTR /I "SQL SERVER"') DO (SET SQLBUILD=%%A)

  ECHO "%SQLBUILD%"

  CD %WORKINGDIRECTORY%

  PAUSE