How to run sqlcmd.exe from PowerShell

Question

I'm trying this and it's failing

PS C:\Users\MooMin>$i = "MySQLInstanceName"
PS C:\Users\MooMin>& sqlcmd -S $i -E -q"SELECT @@VERSION"

I get this error:

Unrecognized token in source text.
At line:1 char:31
+ & sqlcmd -S "$i" -E -q"SELECT  <<<< @@VERSION"
    + CategoryInfo          : ParserError: (:) [], ParentContainsErrorRecordException
    + FullyQualifiedErrorId : UnrecognizedToken

What am I doing wrong?

vonPryz · Accepted Answer · 2014-01-08 13:23:29Z

1

A space is missing between -q and tsql statement. Try like so,

sqlcmd -S $i -E -q "SELECT @@VERSION"

answered Jan 8, 2014 at 13:23

vonPryz

24.3k10 gold badges58 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mark Allison Over a year ago

Interesting that it works in cmd.exe without the space, but not in PowerShell

Collectives™ on Stack Overflow

How to run sqlcmd.exe from PowerShell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related