user2351804 user2351804 - 5 months ago 24
SQL Question

SQLCMD MODE - Incorrect syntax near 'S'

In SSMS, when I execute

sqlcmd -S "flynetSrv"


I get :


Msg 102, Level 15, State 1, Line 3

Incorrect syntax near 'S'.


I am already connected to the server through SSMS

I also tried

sqlcmd -d "dbname1"



Msg 102, Level 15, State 1, Line 3

Incorrect syntax near 'd'.


Please help?

Answer

sqlcmd is an utility intended to be used in a command prompt

You cannot use it in a SQL Server Management Studio (SSMS) query window

You can only write or edit SQLCMD scripts within the query window enabling the SQLCMD mode (Query menu -> SQLCMD Mode)

From MSDN - Editing SQLCMD Scripts with Query Editor:

To use the Database Engine Query Editor to write or edit SQLCMD scripts, you must enable the SQLCMD scripting mode.

Comments