Formatting fails

torsten.strauss

Hi!

The following statement fails when trying to format.
Guess the reason is that the file_name is not wrapped in brackets, which should be done by SQL prompt for my understanding.

SELECT
fil.name AS file_name
FROM
sys.master_files AS fil

Thanks for looking into this!

Torsten

Anu D

Hi Torsten,

Thanks for your post!

I was not able to replicate the issue as I was able to format the code you sent in.

Can you confirm the detailed version of SQL Prompt you have installed?

Harry Frankish

Hi Torsten

Please could you send us your formatting style. This will help us reproduce the problem. The default location for the style files is C:Users<user>AppDataLocalRed GateSQL Prompt 7StylesV2

Many thanks
Harry