LOGINPROPERTY is not recognized as a reserved word.
IATDBA
Posts: 2 New member
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))
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))
Tagged:
Answers
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,