SQLCMD - Missing expression after unary operator...

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Express » SQLCMD - Missing expression after unary...

SQLCMD - Missing expression after unary operator...

Rate Topic

Display Mode

Topic Options

Author

Message

sclavoie

Posted Wednesday, February 22, 2012 12:08 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 23, 2012 7:12 AM
Points: 1, Visits: 3

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:\>

Post #1256219

Suresh B.

Posted Monday, March 05, 2012 2:22 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 6:40 AM
Points: 1,075, Visits: 5,115

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

Post #1261454

« Prev Topic | Next Topic »

Permissions