BUG in SQL Prompt 9.1.14.5213

BillSanscrainte

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

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

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