How Do I Control SQL Prompt/SSMS Startup Options

• 

  Hi Bob,

  
  

  Thank you for your questions regarding SQL Prompt.

  To answer your first question. You can disable the Tab History, so that the previous sessions tabs do not open when SSMS is opened.
  

  To do this. You can navigate to SQL Prompt menu -> Options

  ​
  

  
  

  In the options menu, you can navigate to 'History' and un-check 'Enable tab history'
  

  
  

  You can find more information on Tab history here: https://documentation.red-gate.com/sp/ssms-tab-management/tab-history
  

  
  

  
  

  For your second question, the way to turn off SQL Prompt in SSMS is to log out of the license activation screen.
  

  You can do this by navigating to SQL Prompt menu -> Options -> Manage License
  

  ​
  

  
  

  You will want to sign out in order to deactivate SQL Prompt
  

  ​

  To reactivate SQL Prompt, you can use the same navigation path to sign back in.
  

  
  

  I hope this helps

  Thank you,

  Mac_F October 23, 2019 23:42

  - 0 +
• 
  Hi @Bob_Agresti
  
  I'd follow on from what Mac said and add that you can keep Tab History enabled, but you can uncheck "Restore open tabs when SSMS starts" to stop the tabs from automatically reopening.
  
  Hope this helps.
  
  Tom

  TomW October 24, 2019 09:14

  - 0 +
• 
  That's exactly what I needed. Thanks!

  Bob_Agresti October 25, 2019 13:45

  - 0 +

Add comment

Please sign in to leave a comment.