Cannot copy/paste from Search text

A free Management Studio add-in to search for SQL in your databases

Cannot copy/paste from Search text

Postby andomar » Tue Apr 24, 2012 11:49 am


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
Posts: 14
Joined: Sun Jan 16, 2011 10:01 am

Postby PDinCA » Tue Feb 12, 2013 6:13 pm

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......
Posts: 543
Joined: Mon Jul 25, 2005 10:42 pm
Location: Irvine, CA, USA


Postby rzaks » Tue Apr 16, 2013 9:09 am

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.
Posts: 1
Joined: Tue Apr 16, 2013 9:05 am

Postby Adam » Tue Apr 01, 2014 10:34 am

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.

SQL Search Development Team
Posts: 24
Joined: Tue May 27, 2008 12:40 pm
Location: Cambridge, England

Postby Adam » Thu Apr 03, 2014 9:50 am

We’ve continued to research into this bug and have found a fix.


- Restart SSMS
- Go to Tools -> Options
- Expand “Environmentâ€
Posts: 24
Joined: Tue May 27, 2008 12:40 pm
Location: Cambridge, England

Return to SQL Search Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests