How can we help you today? How can we help you today?

Additional Space after TO

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


torsten.strauss
0

Comments

3 comments

Sort by
  • 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
    krzysztofkroczak
    0
  • torsten.strauss
    Thanks a lot for your support!
    Torsten
    torsten.strauss
    0
  • 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!


    torsten.strauss
    0

Add comment

Please sign in to leave a comment.