Compatibility with SQLCMD mode?

weswinkler

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.

Linda Hawksworth

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.