LOGINPROPERTY is not recognized as a reserved word.

IATDBA

SQL Prompt keeps bracketing the term LOGINPROPERTY incorrectly.
How can I make it stop doing that.

For now, my only option is to turn off auto bracketing entirely. I do not like this as a solution since our standard includes bracketing of user labels.

DECLARE @PWD_varbinary VARBINARY(256)
DECLARE @LoginName_in sysname

--Original Code:
SELECT @PWD_varbinary = CAST(LOGINPROPERTY(@LoginName_in, 'PasswordHash') AS [VARBINARY](256))

--SQL Prompt Formatted code: v v
SELECT @PWD_varbinary = CAST([LOGINPROPERTY](@LoginName_in, 'PasswordHash') AS [VARBINARY](256))

Jessica R

Thanks for pointing this out, @IATDBA!

I've logged a bug for this with internal reference SP-6837 and we will post any updates to it here.

IATDBA

[code in original post]

krzysztofkroczak

Hello @IATDBA ,

We fixed this issue in our latest version of SQL Prompt <9.1.2.4363> (installer here).

You can find more information about this release in this forum post.

Kind regards,