Compatibility with SQLCMD mode?
weswinkler
Posts: 54 New member
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.
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.
Comments