SQL Search Feature Suggestions
Welcome to the SQL Search feature suggestion list. Find out more information about SQL Search at http://www.red-gate.com/products/sql-development/sql-search/
If you have any questions, need help or have found a bug in SQL Search, please visit the forums at http://www.red-gate.com/messageboard/viewforum.php?f=114.
-
Let me configure the maximum number of results returned
I understand the reasoning behind limiting the search results to 150 results, but it would be useful to have the ability to change this as needed.
109 votes -
Option to include/exclude comments in search
Here is an example of a search of what is returned if I search the following text "acft_flt_info"
SELECT *
FROM Test.DBO.VW_FLT_INFO3 (NOLOCK)
-- From acft_flt_info Removed
where Schd_Dep_Date>= @FromDateBut this code has been updated to the new view, If I was able to exclude comment text out of my search then this text would not return. I would I
to exclude this object because I do not care about it.Also for the most part the view dependencies does not work for all case since it will only look in the current database and also does not work…
70 votes -
Allow OR/AND/NOT Searches
Allow searches using any combination of AND/OR/NOT and parens. A minus in front of a keyword works for NOT, like Google does.
62 votes -
54 votes
-
Option to search jobs
Frankly very surprised Version 1.0 didn't have this. Doesn't even seem like it would be a feature consideration. If you have a search tool, shouldn't it be expected to search the *entire* SQL Server, not just part of it? I wonder how many people assume it searches jobs, which after all are stored in a system database, and never realize they may be missing some references?
43 votes -
Format and color code the code view section
This is in all of your other applcitions, I was a little surprised it wasn't in SQL Search.
34 votes -
Add "alter object" next to "select object in object explorer"
For example on a stored procedure, it's time consuming to first click select object in explorer, then right click on the object, then click modify. For a table, same, but clicking design. Plus sometimes if the database sproc isn't expanded yet its slow as the left side menu bounces around expanding first...
26 votes -
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)
26 votes -
Add "Find Next/Previous" buttons in the Text area
Add "Find Next/Previous" buttons in the Text area, so, it will jump to the next occurrence of the searched term (highlighted) in the text.
THNX
Jermy23 votes -
Provide the column name when the match is a column
At this time it just shows column match, but not the name of the column, making this only partially useful for detail on the column name and type I am searching for.
21 votes -
Multiple searches open at the same time
You cannot open multiple search tabs in SSMS. This might be by design, but the ability to have multiple search tabs open at the same time rather than having to open new SSMS windows would make the product more flexible and allow easier searching into "child" issues found from the first search result.
21 votes -
Search for synonym base object name
Search for object that synonym is created for (select name, base_object_name from sys.synonyms - base_object_name)
20 votes -
Go to definition in search resultset
It could be helpful to go to definition of the selected object directly in a new SSMS window
20 votes -
Add option to the context menu for a result to open the item for modification
Double clicking a result should open the item for me to modify. Most of the time I'm looking for a stored procedure, often I've got the exact name or I know roughly the name and I'm using SQL Search to quickly get to it. When I select the item in the results I'd like to be able to right click and go straight to modify it.
At the moment I can double click and jump to that item in the Object Explorer, then right click and go to modify (or use the keyboard to right click and then press Y…
19 votes -
Search and Replace
The ability to search for text in all object and replace them with your other text.
Motivation:
For e.g. Currently I needed to change the size of a certain parameter (varchar(50) to varchar(255) that is used in 90 stored procedures. I had to open up all 90 stored procedures, and then did a search and replace.19 votes -
Remember the location of the SQL Search toolbar
Is there any way to make SSMS remember where the SQL Search toolbar is placed? Every time I start SSMS, SQL Search takes up an entire toolbar slot above my other two toolbars. I'd rather have it alongside the others leaving more screen real estate for scripts, etc
15 votes -
Option to search only object names
To have an option to seach only the object names and when the term matches on object name, do not list the matches on text because it's obvious.
14 votes -
Exclude List like SQL Compare
As in SQL Compare, allow us to filter out extraneous objects, e.g., sp_MS% for replication objects I don't care about.
13 votes -
Dynamically update SqlServer instance dropdown
As connections to different Sql Servers are opened and closed, it would good if the dropdown of instances could reflect that. Currently if Search is open and I open a connection to a new instance I have to close Search, make sure I click on something in the new instance in Explorer and then re-open Search.
13 votes -
Export filtered list
When I've performed an Impact Analysis, allow me to "hide" an object that is of no interest in the object list, then "export to..." Excel-format, or tab-delimited list, so I can pull the list into my Word or other impact document/checklist.
13 votes
- Don't see your idea?