What are the challenges you face when working across database platforms? Take the survey

Compatibility with SQLCMD mode?

weswinklerweswinkler Posts: 54 New member
edited September 28, 2009 5:23AM in SQL Prompt Previous Versions
SQLPrompt does not play well with SQLCMD mode.

I have begun working on projects generated with the Microsoft Visual Studio Team Edition Database Developer Version (aka DataDude). Many of the scripts must be run in SQLCMD mode in order to utilize project variables, stored in *.sqlcmdvars files.

When such a query is loaded into the SQL Management Studio and the query session is set to SQLCMD mode, it parses correctly and executes correctly. However, SQLPrompt cannot perform any layout functions, claiming there are errors.

When will SQLPrompt support SQLCMD mode?

Note: the same applies to SQLRefactor.


  • Options
    Other customers have requested SQLCMD support for SQL Prompt. I have added your comments and ticket reference to the issue in our tracking system. It will be considered for a future release of SQL Prompt although we can't guarantee if/when it will be included.
Sign In or Register to comment.