InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 19:00:39 GMT20http://www.sqlservercentral.com/Forums/Topic1256219-324-1.aspxTry this:SQLCMD -S CONTOSOWXP01\SQLEXPRESS -Q "CREATE LOGIN [NewUser] WITH PASSWORD = 'password', DEFAULT_DATABASE=[Mydatabase], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF"Mon, 05 Mar 2012 02:22:13 GMTSuresh B.http://www.sqlservercentral.com/Forums/Topic1256219-324-1.aspxNoob 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=OFFSqlcmd: '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:\>Wed, 22 Feb 2012 12:08:24 GMTsclavoie