133 results found
-
Find with spaces
Currently if I search for x y (x,space,y), it will return all instances of x or y.
If I make it "x y" it finds nothing. There are many times when I want to find the coexistence of two very common terms, so having the latter search (or a variation) return results would be helpful.15 votes -
SSMS Schema Folders compatibility
This add-on moves schemas to a folder (e.g. Database -> Tables -> Schemas -> list of individual tables). Both add-ons dramatically increase's SSMS' usability. Search for obvious reasons. Schema Folders for easy keyboard jump to objects (e.g. typing tab to jump to "TableName" instead of dbo.tab). But the 2 don't work together. "Select object in Object Explorer" no longer works once I have Schema Folders installed. It often ends up somewhere in the sys folder, without actually jumping to the object.
Having both work would be gravy for my data warehouse (100s of tables/procs) means lots of scrolling otherwise.
Add-on…
15 votes -
In the results pane, add highlight notches to scrollbar to indicate search term locations.
When I do a search, the results pane that contains the text of the object I currently have selected will highlight the search term within the text, but if the object has a large amount of text, I need to scroll and find it. A notch on the scrollbar, like what Google Chrome does with a find-on-page Ctrl+F search, will help with zeroing in on the term within the object's text.
15 votes -
Show modify_date of objects
I would be great if we could see the last modify_date of the objects in the results grid and sort by last modified
14 votes -
Save Search Results
Please provide an option to save the search results to a file. This is very helpful when there are a lot of objects that match the search criteria.
14 votes -
Show in results window each location of matching text with ability to jump to next found match (like search feature in SSMS)
Similar to SSMS now where it highlights the side bar with each instance of the matched string, in the results window show me each instance that text was found.
Also like the SSMS find feature, allow me to jump to each instance of the matching text within the page.14 votes -
Specify different user to run a database search as instead of the current logged in user
SQL Search tries to runs the search as the logged in user but sometimes that will not work specifically on cross domain scenarios with a one way trust.
In these cases we have to use the RunAs Windows command with SSMS so we can connect to the database on the other domain.SQL Search does not do the same behavior as most times indexing or any search will fail because it cannot connect to the database because it uses the logged in user account
13 votes -
Please let me select and change fonts for SQL Search.
I'd like to use my preferred monospaced font cosnsistent with SSMS. I cant find any option to change font in SQL search.
It'll be absolutely great if I could change font for SQL search results.
13 votes -
Copy colums from the search grid
it would be very helpful to be able to copy and paste a list of objects from the search grid rather than the whole line.
13 votes -
Search to include schema names
It would be very beneficial if I could search for objects with a certain schema across the databases I choose. I.e. SQL Search trigger on letter-sequences in schema names, just as in table or column names.
As it is, I can only find those objects if they are referenced elsewhere with their schema given (e.g. a stored procedure or a view will give me a hint that a schema exists in a database in a galaxy, far, far away).
12 votes -
Print List
Once the list is generated allow the printing or export of the list.
Cheers
12 votes -
A set of defaults. When opened it always selects "All Objects". It would be nice to have a way to limit this to "X" by default.
A set of defaults. When opened it always selects "All Objects". It would be nice to have a way to limit this to "X" by default.
11 votes -
Open in Excel
Would be nice to have option Open in Excel the search result.
11 votes -
Ability to PERSIST SETTINGS.
Ability to maintain settings between searches. When I switch back and forth and open and close it, it goes back to SEARCH ALL, but when I am working, I am usually focused on something and it's quite painful to have to reset the settings almost every-time., We need a checkbox option to PERSIST SETTINGS.
When I am working on something I am usually working in one or two databases but we have 50 databases, I don't need to search all those all the time. I am usually looking for where column names are within tables, I love all the features…
10 votes -
Allow Multiple Word Search
We have over 200 tables and over 1000 stored procedures. I often need to search on two words. The current "Match whole words only" literally searches for "this word", but I often need it to search for all objects that have exactly "this" and "word". When I search try without the "Match whole words only", I end up with a LOT of results that have words that are similar to "this" and "word", but aren't an exact match.
I've also tinkered with the wildcards, but that only seems to apply to on character at a time. Maybe I'm doing something…10 votes -
Have the ability to remove the default of all databases.
Having the search start automatically with all database is frustrating when you have hundreds of databases on an instance.
You should be able to initiate the search when you're ready, or stop the one that is currently running.10 votes -
Allow to search Azure Managed Instances
Allow to search Azure Managed Instances
10 votes -
Filter object explorer by schema
Chose schema from combo box and all tables, view-s, procedures, functions, .... are filtered by schema in Object Explorer.
10 votes -
Navigate back and forth between occurrences in search result
I need a way to move between occurrences of a SQL Search search result (either keyboard shortcut or button/icon).
Lets say I have a bunch of long stored procedures and the name of a certain table occurs a few times within each of those procedures. I use SQL Search to search for the name of that table.
Right now, each occurrence of the that table name will be highlighted in the code, but I have to manually scroll through the code to find the highlighted occurrences. This can become a pain if I have to scroll both horizontally and vertically.…
10 votes -
Need option to turn off auto search
I would like to have the ability to turn off the "auto search" function. Whenever I enter a search phrase, I feel "rushed" to get it entered before the auto-search kicks in. Many times it starts finding results as I'm typing and then does not search again when I complete my typing. At the point I have to force a re-index.
It would be helpful to be able to turn that off and then pressing Enter or using a separate search button would initiate the search.
9 votes
- Don't see your idea?