Comments
Sort by recent activity
Hi Chris,
Are you talking about the colour that comes up when you click on an object?
If so, there are instructions on how to change it through in the linked release notes.
Please let me know if this is not what you meant!
Best regards,
David / comments
Hi Chris,
Are you talking about the colour that comes up when you click on an object?
If so, there are instructions on how to change it through in the linked release notes.
Please let me know if th...
Hi Michael,
Unfortunately SQL Prompt doesn't recognise SSMS installs if they have been installed after Prompt.
If you re-install SQL Prompt (uninstall and reinstall, repairing won't work), it should show up in SSMS 2016.
A direct link to 7.2.4.291 can be found here.
Best regards,
David / comments
Hi Michael,
Unfortunately SQL Prompt doesn't recognise SSMS installs if they have been installed after Prompt.
If you re-install SQL Prompt (uninstall and reinstall, repairing won't work), it shoul...
Hi Michael,
Not a problem! Let us know if you have any more questions.
Best regards,
David / comments
Hi Michael,
Not a problem! Let us know if you have any more questions.
Best regards,
David
Hi Karen,
I'm glad to hear it!
Let us know if you have any more questions!
Best regards,
David / comments
Hi Karen,
I'm glad to hear it!
Let us know if you have any more questions!
Best regards,
David
Hi Karen,
SQL Prompt keeps a cache containing data about databases it's connected to locally, and doesn't know about changes to the database unless it's told about them. You can force SQL Prompt to refresh the cache by using Refresh suggestions (Ctrl + Shift + D).
If you're connecting to small databases you could turn on the Automatically refresh suggestions feature in the Experimental features options page - this will check for changes to the database every few minutes and will also refresh the cache when you run a script that contains a modification statement.
Please let me know if this helps you.
Best regards,
David / comments
Hi Karen,
SQL Prompt keeps a cache containing data about databases it's connected to locally, and doesn't know about changes to the database unless it's told about them. You can force SQL Prompt to...
Hi Jim,
Thanks for sending this through!
I can reproduce this and am looking into a fix now.
Best regards,
David / comments
Hi Jim,
Thanks for sending this through!
I can reproduce this and am looking into a fix now.
Best regards,
David
Hi a.higgins,
We've had feedback both ways to count or not count JOINs as a subsequent item, so we'll look into adding an option so people can choose.
Best regards,
David / comments
Hi a.higgins,
We've had feedback both ways to count or not count JOINs as a subsequent item, so we'll look into adding an option so people can choose.
Best regards,
David
Hi a.higgins,
The top clause has caused us quite a few problems. We'll look into getting this sorted.
It is possible to get this behaviour you want by setting the following option: [image]
This won't keep it one line if there are multiple items, but you could combine this with the "Collapse statements shorter than x characters" option.
If this doesn't work for you, I'll take a look to see if the options could be reworked.
Best regards,
David / comments
Hi a.higgins,
The top clause has caused us quite a few problems. We'll look into getting this sorted.
It is possible to get this behaviour you want by setting the following option:
This won't keep ...
Hi SR1978,
Unfortunately SQL Prompt only works with Microsoft SQL Server in SQL Server Management Studio and Visual Studio.
Best regards,
David / comments
Hi SR1978,
Unfortunately SQL Prompt only works with Microsoft SQL Server in SQL Server Management Studio and Visual Studio.
Best regards,
David
Hi dwilliamson,
We've got a fix for this in the latest beta, which you can download from here or from Check for updates.
Please let us know if it solves your problem!
Best regards,
David / comments
Hi dwilliamson,
We've got a fix for this in the latest beta, which you can download from here or from Check for updates.
Please let us know if it solves your problem!
Best regards,
David