sqlcmd.exe does not show any interactive output on the console (CMD and Powershell)

Question

I just freshly installed SQL Server Express 2014 via Chocolatey. The service is currently running.

When I run this inside my CMD or Powershell:

> sqlcmd -e -S .\SQLEXPRESS
1> sp_databases;
2>

I get no output, it just goes to the next prompt line.

However when I use this style, I do get output:

> sqlcmd -e -S .\SQLEXPRESS -Q "sp_databases;"
sp_databases;
DATABASE_NAME                                                                                                                    DATABASE_SIZE REMARKS

-------------------------------------------------------------------------------------------------------------------------------- ------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
master                                                                                                                                    7808 NULL

model                                                                                                                                     5312 NULL

msdb                                                                                                                                     37632 NULL

tempdb                                                                                                                                    2560 NULL

What could be the reason for this? I have no special configuration for the CMD or Powershell except some colour changes of the console.

For reference: stackoverflow.com/questions/4944165/…

CMCDragonkai
– CMCDragonkai

2017-01-14 12:19:08 +00:00
Commented Jan 14, 2017 at 12:19 — CMCDragonkai
– CMCDragonkai, Commented Jan 14, 2017 at 12:19

CMCDragonkai · Accepted Answer · 2017-01-14 12:14:31Z

24

Turns out I just needed to run GO at the end of each command. Silly.

answered Jan 14, 2017 at 12:14

CMCDragonkai

6,38212 gold badges61 silver badges103 bronze badges

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

2 Comments

Zimano Over a year ago

Didn't work for me. The number resets to 1, though, as in 1>

Tayyebi Over a year ago

Didn't work for me too.

Collectives™ on Stack Overflow

sqlcmd.exe does not show any interactive output on the console (CMD and Powershell)

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related