Red Gate forums :: View topic - Cannot copy/paste from Search text
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Search 1
SQL Search 1 forum

Cannot copy/paste from Search text

Search in SQL Search 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
andomar



Joined: 16 Jan 2011
Posts: 14

PostPosted: Tue Apr 24, 2012 12:49 pm    Post subject: Cannot copy/paste from Search text Reply with quote

Hi,

I recently upgraded to SSMS 2012.

When I try to copy/paste from SQL Search, this error appears:



This is fairly inconvenient, is this a known issue?

Thanks for your reply,
Wessel Troost
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 499
Location: Costa Mesa, CA, USA

PostPosted: Tue Feb 12, 2013 7:13 pm    Post subject: Reply with quote

It gets worse. If you take note of the 2nd sentence in the dialog, it talks about not having a saved document... So, I clicked the SAVE button!

It brings up the save dialog per usual - looking good... BUT, once the file name has been assigned and the document saved, notice that the tab titile doesn't change. If you happened to have ANOTHER SQL Script open (I had just opened a Modify of an SP), THAT now bears the name you just assigned.

On the plus side, you can now highlight and Ctrl+C.

So, my advice is to open an empty query then open SQL Search, save, ostensibly, the SQL Search document, and leave the empty script open. Fudge - yes, but it works...

Now if only Red Gate had added an auto-response to this original ticket 10 months ago...

Care to fix this simple thing, please, Red Gate - SSMS2012 is now mainstream......
Back to top
View user's profile Send private message
rzaks



Joined: 16 Apr 2013
Posts: 1

PostPosted: Tue Apr 16, 2013 10:09 am    Post subject: Workaround Reply with quote

I keep 2 instances of SSMS 2012 running - one with SQL Search another without. The one with SQL Search does not have any tabs open, so you can copy in one instance of SSMS and paste to another.
Back to top
View user's profile Send private message
Adam



Joined: 27 May 2008
Posts: 19
Location: Cambridge, England

PostPosted: Tue Apr 01, 2014 11:34 am    Post subject: Reply with quote

We are looking into resolving this issue, however it seems 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
SQL Search Development Team
Back to top
View user's profile Send private message
Adam



Joined: 27 May 2008
Posts: 19
Location: Cambridge, England

PostPosted: Thu Apr 03, 2014 10:50 am    Post subject: Reply with quote

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 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)

Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group