Activity overview
Latest activity by BillSanscrainte
Thanks Steve! / comments
Thanks Steve!
SQLPROMPT Error formatting query hint IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX
Example:SELECT * FROM sys.tables -- formatting works greatSELECT * FROM sys.tables OPTION (IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX) -- formatting fails with error "Error laying out sql. SQL Prompt e...
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
/ comments
After applying update still getting same behavior as before:SELECT ipAddress = CAST(CONNECTIONPROPERTY('local_net_address') AS VARCHAR(48))returnsSELECT ipAddress = CAST(CONNECTIONPROPERTYVARCH...