Additional Space after TO

torsten.strauss

Hi Redgate Team,

SQL Prompt will add an additional space after TO
[code]
:SETVAR BackupPath "C:\Program Files\Microsoft SQL Server\MSSQL14.MYSQLSERVER2017\MSSQL\Backup\"
BACKUP LOG AdventureWorks2017 TO   DISK = '$(BackupPath)\AdventureWorks2017.trn'
GO
[/code]

Would be nice to see a fix in the next release...
Thanks!

Torsten

krzysztofkroczak

Hello @torsten.strauss,

We fixed this issue in our latest version of SQL Prompt 9.1.15.5260.

You can find more information about this release in https://forum.red-gate.com/discussion/83138/the-latest-stable-build-of-sql-prompt-is-9-1-15-5260-6th-june

Kind regards,
Krzysztof

torsten.strauss

Thanks a lot for your support!
Torsten

torsten.strauss

Hi!

Again the issues is there in the new release:

[code]

-- Backup the database to ensure the database is not running in pseudo
-- simple mode
:SETVAR BackupPath "C:\Program Files\Microsoft SQL Server\MSSQL14.MYSQLSERVER2017A\MSSQL\Backup\"
BACKUP DATABASE test
TO    DISK = '$(BackupPath)\test.bak'
WITH
    INIT, FORMAT, STATS = 10;
GO

[/code]

Version 9.2.4.6028 

Thanks for fixing it!