geography data type properties Lat and Long

bharkness

I run into this problem frequently with SQL Prompt - whenever my query returns the Lat and Long properties of a geography column, the SQL Prompt suggestions are disabled for the entire query. If I temporarily comment those property references out, the suggestions come back.

with property references:


without property references:


Is there a setting or configuration issue here? Or am I doing something wrong?

I am using SQL Prompt version 8.0.3.1587

krzysztofkroczak

Hi,

Sorry for the problem.

I tried to recreate the problem and I couldn't. Can you give us more information, such as which SSMS do you use and send us your logs? Please, enable verbose logging first.
You can do it by:
https://documentation.red-gate.com/display/SP8/Finding+the+SQL+Prompt+log+files

Best regards
Krzysztof