SQLCMD - Missing expression after unary operator...

• sclavoie

  SSC Veteran

  Points: 243

  More actions

  February 22, 2012 at 12:08 pm

  #268690

  Noob to using SQLCMD and getting this when running script from Powershell. Any help would be greatly appreciated!!!!

  PS C:\> SQLCMD -S CONTOSOWXP01\SQLEXPRESS CREATE LOGIN [NewUser] WITH PASSWORD = 'password', DEFAULT_DATABASE=[Mydatabase], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

  Sqlcmd: 'CREATE LOGIN [NewUser] WITH PASSWORD = password DEFAULT_DATABASE=[Mydatabase] CHECK_EXPIRATION=OFF CHECK_POLIC

  =OFF': Unexpected argument. Enter '-?' for help.

  PS C:\> -?

  Missing expression after unary operator '-'.

  At line:1 char:2

  + - <<<< ?

  PS C:\>

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  March 5, 2012 at 2:22 am

  #1454683

  Try this:

  SQLCMD -S CONTOSOWXP01\SQLEXPRESS -Q "CREATE LOGIN [NewUser] WITH PASSWORD = 'password', DEFAULT_DATABASE=[Mydatabase], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF"