How to Start SQL Prompt
silverskunk
Posts: 2 New member
in SQL Prompt
I accidentally hit some key combination that threw me out of SQL Prompt. Now I can't figure out how to get SMS to run using SQL Prompt. Any suggestions?
Tagged:
Best Answer
-
Alex B
Posts: 1,157 Diamond 4
Hi @silverskunk,
The Ctrl+Shift+P toggles enabling and disabling the suggestions at all; refreshing the suggestions will only work if they are already enabled.
If you had disabled and then re-eanbled the suggestions it may be that they needed to be refreshed, but it seems likely that the suggestions were disabled by accidently using the key combination above.
If SQL Prompt stops suggesting things, the first thing to check is that they are enabled and then refresh the suggestions after that!
Kind regards,
Alex
Answers
When you say "threw you out of SQL Prompt" and "SSMS to run using SQL Prompt" is it that the SQL Prompt menu no longer appears in the menu list at the top of the SSMS window (between Tools and Window)?
Or is it that SQL Prompt suggestions are no longer being suggested? This is the only thing I can think of that would occur from a combination of key presses (Ctrl+Shift+P enables and disables suggestions).
If you can let me know whether the menu is there or not and if it is appearing then what functionality is missing if it's not the suggestions and I can hopefully help out more!
Kind regards,
Alex
Have you visited our Help Center?
Thanks,
Lynne