Posts
Sort by recent activity
SQLCMD macros not supported
Consider the following valid script which runs in SSMS without issue:
:setvar x x
SELECT *
FROM sys.tables
Reformating the above using SQL Prompt 5 results in the following error:
SQL Promp...
STATS not supported by master..sqlbackup
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE does not support the STATS. Is there a way to display progress when restoring from a script?
SQLCMD macros :setvar and $()
I use SQLCMD macros. A simple example would be::setvar server foo
:setvar database bar
:connect $(server)
USE $(database)
SQL Prompt chokes on these. Do you have any plans to sup...