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

LOGINPROPERTY is not recognized as a reserved word.

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))
Fahim
0

Comments

3 comments

Sort by
  • IATDBA
    [code in original post]
    IATDBA
    0
  • 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.
    Jessica R
    0
  • 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,
    krzysztofkroczak
    0

Add comment

Please sign in to leave a comment.