Support for set statistics io, time on;

• 
  Hi @ggeier ,
  
  Thanks for reaching out to us regarding this.
  
  So that we can be reproduce this, would you mind providing some example syntax for this?

  Dan_J January 19, 2022 16:59

  - 0 +
• 
  The SQL is: set statistics time, io on;

  ggeier2 January 20, 2022 15:22

  - 0 +
• 
  Hi @ggeier
  
  Thanks for your last comment on this, my apology for the delay in coming back to you.
  
  I have been discussing this with our development team, however we feel we need to clarify exactly what you mean when you say this syntax isn't supported?
  
  From my own testing, I can see that suggestions cease to be given beyond 'set statistics time'. Is this what you mean?

  Dan_J January 26, 2022 10:53

  - 0 +
• 
  Yes, that's correct. There are no more valid suggestions after typing "set statistics time". But also, there are incorrect suggestions, so I end up typing the wrong SQL unless I remember to hit "esc" to close out of SQL Prompt.

  ggeier2 January 26, 2022 14:26

  - 0 +
• 
  Hi @ggeier2
  
  Thanks for your previous update on this, our development team are now looking into this. 
  
  We will come back to you again as soon as we have an update for you.

  Dan_J February 04, 2022 07:24

  - 0 +
• 
  Hi @ggeier2
  
  Just to advise that a fix for this will be included in the next release of SQL Prompt, which I am hopeful will be next week.

  Dan_J February 04, 2022 09:19

  - 0 +
• 
  Thank you!

  ggeier2 February 04, 2022 15:47

  - 0 +
• 
  Hi @ggeier
  
  This fix has now been released. You can download the latest version here:
  https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.11.2.26629.exe 
  

  Victoria W February 10, 2022 12:56

  - 0 +
• 
  Awesome! This works perfectly. Thank you!

  ggeier2 February 10, 2022 13:10

  - 0 +

Add comment

Please sign in to leave a comment.