Red Gate forums: SQL Search 1

RE: Cannot copy/paste from Search text

rzaks — Tue, 16 Apr 2013 09:09:05 GMT

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.

Jobs not searched?

GGinBerkeley — Thu, 11 Apr 2013 23:41:47 GMT

I'm working on a new project, on a database that has many SQL Server jobs.

I had hoped that SQL Search could help me locate which jobs are calling out particular stored procedures (e.g., show me all jobs that invoke sproc 'foo').

Sadly, SQL Search seems to fail badly in this instance - jobs are completely ignored, apparently.

So I have had to resort to using this query instead:

use msdb
go
select sj.name as job_name, st.command
from sysjobs sj
join sysjobsteps st
on sj.job_id = st.job_id
where st.command like '%mysprocname%'

Are there any plans to change this? It seems like a major oversight/bug to not search for jobs.

Thx.

RE: Cannot copy/paste from Search text

PDinCA — Tue, 12 Feb 2013 18:13:43 GMT

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

RE: SQL Search only searches modified objects

delbaz — Mon, 04 Feb 2013 20:22:07 GMT

First, thank you for your answers.
I also had the same problem recently, and your answer fixed my problem.

However, I now have a very serious nagging doubt about all the searches that I have done in the past using SQL Search: What if I missed the update of a field in an SP because the search didn't show it?

Does anyone know if Redgate is looking at fixing this problem in a future release?
Thank you.

RE: Search not working for a DB

delbaz — Mon, 04 Feb 2013 20:19:53 GMT

RE: Select object in Object Explorer doesn�t works

nookie — Thu, 31 Jan 2013 07:49:53 GMT

About the same problem for me. When hitting "Select object in Object Explorer" link, nothing happens !

I'm working on SSMS/SQL Server 2008 R2 v10.50.4260

Thanks for your answers.

Searching in synonyms request

iamtester — Wed, 23 Jan 2013 13:33:08 GMT

Hello,

Please add searching in synonyms

Not much of the search functionality seems to work

diversteve — Thu, 17 Jan 2013 03:56:38 GMT

I am tyring to locate all uses of a temp table, so I am trying to search for the '#' character. That returns nothing, but if precede it with a space, then it returns values.

I then tried to search on 'create table #' with exact match checked. It returned 10 results, but did not find a stored procedure that contains 'create table #depts' but did find 'create table #rate'.

This is very unreliabe!!!

I downloaded and installed the latest version tonight.

I went back to try a few more things. I am also running into the limit of 150 results as being an issue.

While I am on a role, I do not like that I cannot move the 'SQL Search' toolbox either. I am so used to the 'New Query' function being in that location.

Overall, I am a huge fan of RedGate products, but so far this one has way too many issues.

SSMS Slow Startup with SQL Search

renskemo — Mon, 14 Jan 2013 21:23:57 GMT

I love using SQL Search, but I have been experiencing extremely slow startup times for SSMS 2008 R2 and I finally narrowed it down to SQL Search today. When SQL Search 1 is not installed, SSMS starts up quickly as normal. When SQL Search is installed, there is a long delay - 30 seconds-ish - every time I start SSMS. The delay occurs after the SSMS window comes up but before a new connection is offered. The only other RedGate products I have installed at this point are SQL Compare 10 and SQL Data Compare 10.

SQL Server Management Studio 10.50.2500.0
Windows 7 Professional (64 bit)
Service Pack 1

RE: SQL Search tool searching for data

Adrian00 — Tue, 27 Nov 2012 17:27:18 GMT

Go beyond full text search. Search SQL Server database data for anything without writing queries, no setup, Google-like. Search results can be replaced, removed, saved and shared with others. SQLLocator.com

RE: SQL Search Menu is disappear

rre — Mon, 12 Nov 2012 15:49:23 GMT

Aha! I found it! There is a "new" toolbar called "Red Gate" which was unfortunately disabled at startup. This contains the SQL Search button I was looking for.

Before I had a toolbar which contains only the SQL Search button. I don't know the name from this before. Now, there are two more button SQL Source Control and SQL Test.

SQL Search Menu is disappear

rre — Mon, 12 Nov 2012 15:41:10 GMT

Today I installed the latest version of SQL Search, SQL Prompt and some other Tools of Red Gate. Everything works fine during the installation.

After starting the SSMS (without errors) I was facing that the menu for SQL Search is disappear. I can't find it anywhere inside SSMS. The local installation folder is still there.

I tried the software repair method, but it didn't solve my issue. Could you help me to display SQL Search again so that I can use it?
So far, I get no error and problem reported by running the update process of the Red Gate Installer or on starting the SSMS.

RE: SQL Search tool searching for data

Brian Donahue — Fri, 09 Nov 2012 09:14:30 GMT

SQL Search is for searching DDL text, so it will search the metadata in the database but not the actual data in tables. You could try this stored procedure from MS...

http://gallery.technet.microsoft.com/scriptcenter/c0c57332-8624-48c0-b4c3-5b31fe641c58

SQL Search tool searching for data

bsanta — Thu, 08 Nov 2012 23:34:18 GMT

Hello,

Does anyone know if SQL Search tool allows for searching for data within tables?? I have tried this but have been unsuccessful. It only looks at objects such as procedures, triggers, etc. But I haven't been able to find a way to search for data. Any help would be greatly appreciated.

Thanks.[/i]

RE: Add-in 'SQL Search 1.1' failed to load or caused an exceptio

lotsahelp — Fri, 19 Oct 2012 19:38:30 GMT

Version 1.1.8.20 will not load and no errors / information. Using SSMS 2008 R2 10.50.2806.0