SQLCMD

• padmakumark26

  Mr or Mrs. 500

  Points: 513

  More actions

  February 22, 2017 at 1:56 am

  #321963

  Hi ,
    When i am trying to execute SQLCDM getting following error.
  Sqlcmd: '-i': Missing argument. Enter '-?' for help.
  Following is the script
  Write-Output("`r`n*** Executing CreateHmsDb.sql ***`r`n")

  sqlcmd `
    -U $hmsSysAdminUser `
      -P $hmsSysAdminPassword `
      -S $hmsServer `
    -d master `
      -i $PSScriptRoot/mssql/new/HMS/CreateHmsDb.sql `
      -v hmsDbName=$hmsDbName `
      -v hmsDataName=$hmsDataName `
      -v hmsDataFQFileName=$hmsDataFQFileName `
      -v hmsDataSize=$hmsDataSize `
      -v hmsDataMaxSize=$hmsDataMaxSize `
      -v hmsDataGrowth=$hmsDataGrowth `
      -v hmsFileGroupName=$hmsFileGroupName `
      -v hmsFileGroupFQFileName=$hmsFileGroupFQFileName `
      -v hmsFileGroupSize=$hmsFileGroupSize `
      -v hmsFileGroupMaxSize=$hmsFileGroupMaxSize `
      -v hmsFileGroupGrowth=$hmsFileGroupGrowth `
      -v hmsLogName=$hmsLogName `
      -v hmsLogFQFileName=$hmsLogFQFileName `
      -v hmsLogSize=$hmsLogSize `
      -v hmsLogMaxSize=$hmsLogMaxSize `
    -v hmsLogGrowth=$hmsLogGrowth `

  Thanks,
  Padmakumar

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  February 22, 2017 at 2:20 am

  #1929658

  Is it because of your attempt to concatenate the $PSScriptRoot variable with the rest of the file path?  Perhaps you need to enclose the file path part in quotes, and maybe you have a to use an ampersand or plus sign as a concatenation operator.  And don't file paths use backslashes, not forward slashes?

  John