BUG in SQL Prompt 9.1.14.5213

BillSanscrainte · May 30, 2018 5:35PM

Formatting the statement

SELECT ipAddress = CAST(CONNECTIONPROPERTY('local_net_address') AS VARCHAR(48))

returns

SELECT ipAddress = CAST(CONNECTIONPROPERTYVARCHAR = ('local_net_address')(48));
SSMS v17.7

RichardL · June 7, 2018 2:17PM

Hi @BillSanscrainte

Thanks for your post.

Just to let you know that a new version of SQL Prompt was released yesterday and is available for download in my link below.

ftp://support.red-gate.com/patches/SQLPrompt/06Jun2018/SQLPrompt_9.1.15.5260.exe

I hope this helps.

Best

Richard Lynch.

BillSanscrainte · June 7, 2018 2:38PM

After applying update still getting same behavior as before:

SELECT ipAddress = CAST(CONNECTIONPROPERTY('local_net_address') AS VARCHAR(48))

returns

SELECT ipAddress = CAST(CONNECTIONPROPERTYVARCHAR = ('local_net_address')(48));
SSMS v17.7

Answers