allow text copy in the result panel
After searching we try to copy some text (for example the stored procedure name) in the result panel. This fails with the error: "unsaved documents cannot be cut or copied to the clipboard...." (alert box)
J. Verdurmen
shared this idea
Here are the steps to fix this SSMS issue:
- Restart SSMS
- Go to Tools → Options
- Expand “Environment” on the left and click the “Documents” item
- De-select “Show Miscellaneous files in Solution Explorer”
- Click OK
In order for this to be effective, either restart Management Studio or close/save any unsaved query windows (after which point, new, unsaved query windows should not cause this problem any more)
We are now closing this suggestion so that votes are reallocated.
Thanks
SQL Search Development Team
-
Blaž Dakskobler
commented
If this is a SSMS bug, is there a Connect item for it, so we can vote up?
-
AdminAdam
(Admin, Redgate)
commented
We’ve continued to research into this bug and have found a fix.
Steps:
- Restart SSMS
- Go to Tools -> Options
- Expand “Environment” on the left and click the “Documents” item
- De-select “Show Miscellaneous files in Solution Explorer”
- Click OKIn order for this to be effective, either restart Management Studio or close/save any unsaved query windows (after which point, new, unsaved query windows should not cause this problem any more)
http://ux.red-gate.com/wp-content/uploads/2014/04/copy_and_paste_fix_underlined.png
We'd like to close this post as we believe this is the only fix for this SSMS bug. Please do let us know if you believe this should be kept open.
-
AdminAdam
(Admin, Redgate)
commented
This issue has been present for some time in SQL Search and occurs when you have unsaved query windows open in SSMS, which is quite common.
We are looking into resolving this issue, however it is looking likely that this is out of our control as SSMS could be intercepting the Ctrl + C before it ever reaches SQL Search.
The current work-around for this is to either close or save any unsaved query windows. The forthcoming release will also have 'copy' added to the right-click context menu.
If the symptom described above is not what you are experiencing, or you have anything further to add to this issue, we'd be grateful for more information.
Thanks
Adam -
Nick Gilbert commented
This is a dupe of https://redgate.uservoice.com/forums/101149-sql-search/suggestions/3486080-allow-text-copy-in-the-result-panel
perhaps the votes can be merged?
-
Tom Pester
commented
Just noticed this is a duplicate of http://redgate.uservoice.com/forums/101149-sql-search/suggestions/3486080-allow-text-copy-in-the-result-panel
-
Tom Pester
commented
Yep, I noticed this one too. Seems low haning fruit. Fix for this bug would make the product easy to use again.
-
AdminAdam
(Admin, Redgate)
commented
We're just about to pick up work on SQL Search and this is a bug we will aim to fix.
Thanks
Adam -
Stephen
commented
Just posted a "workaround" on the Forum: http://www.red-gate.com/messageboard/viewtopic.php?p=60292#60292
Quick and Dirty...
