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)
with SQL server 2012 we cant copy any text from the Redgate object definition window as i been do in sql server 2005,2008
now we got the following message from sql server
unsaved document cannot be cut r copied to the clipboard....... etc
really its painfull
Whenever I search for something I would like to have an option to copy portion of the result. For example there is a stored procedure that fails. I don't know exactly what is the name of the proc so I would search for it. When I find it, it displays the script for the stored procedure and I would like to copy a single select from it and execute it directly. I can't do that currently. I have to click on "Select object in Object Explorer" and then display its script before I can copy the select to the clipboard.
We have now started work on fixing this issue for the forthcoming release.
Thanks for your suggestion.
Blaž Dakskobler commented
If this is a SSMS bug, is there a Connect item for it, so we can vote up?
We’ve continued to research into this bug and have found a fix.
- 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'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.
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.
Nick Gilbert commented
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.
We're just about to pick up work on SQL Search and this is a bug we will aim to fix.
Just posted a "workaround" on the Forum: http://www.red-gate.com/messageboard/viewtopic.php?p=60292#60292
Quick and Dirty...