Qualify Object names can't grok subqueries?

• 
  Hi agb,
  
  I just gave this a try and I think we have fixed it in the latest build of the 6.4 beta already if you'd like to give that a try?
  
  If you're still having problems on the latest beta build please let me know and I'll investigate further for you.
  
  Thanks,
  Aaron.

  Aaron L September 12, 2014 04:09

  - 0 +
• 
  Hi Aaron,
  
  Yes, the 6.4 beta resolves this issue - thanks.
  
  PS as a side note, installing the 6.4 beta removed all my "Connection Coloring" settings, and I had to re-educate SSMS which connection was which designation again. I know this is an experimental lab feature so tough luck on me but I thought I would mention it. (Along with the fact that I really like this feature!)
  
  Cheers.

  agb September 12, 2014 06:18

  - 0 +
• 
  Hi agb,
  
  Which version of Prompt were you running before installing 6.4? All the connection colouring settings should be preserved but there's a chance that they didn't get copied over from a previous version if you were on 5. (they are all stored in %localappdata%\Red Gate\SQL Prompt 6 (or 5)\servers.xml, so you might be able to manually copy them across)
  
  Hopefully we'll move this into a full feature of Prompt soon! One of the improvements in 6.4 is you can manually add your own colours/categories. I quite like having a purple category
  
  Thanks,
  Aaron.

  Aaron L September 12, 2014 06:57

  - 0 +
• 
  It was a hiccup. Closed SSMS and re-opened it and all the old colourations returned.
  
  Handy to know where the XML doc lurks tho!
  
  Cheers

  agb September 12, 2014 08:39

  - 0 +
• 

  Aaron Law wrote:

  I quite like having a purple category

  
  Very nice. I have a purple "misc" category now too

  agb September 12, 2014 08:46

  - 0 +

Add comment

Please sign in to leave a comment.