133 results found
-
Schema filter
It would be nice to be able to filter results on schema. We have a number of large databases with multiple schemas. When we're looking for a common phrase or word, it would be nice to be able to select a schema or multiple schemas to narrow down the results.
39 votes -
Script results so we can easily replace text/columns/code in large amounts of tables/views/sprocs and even across databases
In search result windows , multiselect is possible. On right click give option to script out selected objects.
Workaround i use for now:
What i usually do is open sql compare alongside and then select results from a single database and compare them to an empty database, script all out, and then replace create statements with alter.33 votes -
Major KNOWN Issue --- Stop requiring product to login to all databases on server
The product requires you to have at least read access to all databases on provided server... because when the product opens... and db access is lacking... then USER is failing login attempts on PRODUCTION SERVERS to which user has no access. This creates GREAT FRUSTRATION for DBA and AUDITing groups.
32 votes -
Azure Active Directory Authentication for SQL Search
Would be good that SQL Search authenticated through Azure Active Directory, so I could release this tool to many users on my Azure SQL Databases.
If not possible, would be nice to choose which SQL account to authenticate instead of my current account.28 votes -
Default object filter (ignore jobs, constraints, triggers, and other...but include tables, sprocs, views, functions). EVERY time I start se
Default objects filter (ignore jobs, constraints, triggers, and other...but include tables, sprocs, views, functions). EVERY time I start search I have to turn off the objects I don't want (and RARELY want).
27 votes -
In SQL Search, provide facility to stop the search.
The search facility doesn't stop even if you close the window and starts again with the same search. It doesn't have any button to stop the search if some inputs are wrong.
25 votes -
Stop the search once started or at least control when it "starts"
Add a stop/start button to the search process.
If you change the criteria, it immediately starts searching for that criteria before you get a chance to change some of the other parameters.
Worst case scenario it eats up all the memory and crashes SSMS if you search against "All Databases" on a production server.
Give some control back to the UI.25 votes -
Include a dark mode
Allow users to select to use a dark theme for SQL Search, ideally this would pick up from their settings (if on Windows at least)
24 votes -
Add a way to stop automatically searching when I open SQL Search
It remembers the last search term, but not which databases I limited to the last time I searched. So everytime I open it, it tries to search multiple databases that I don't have permissions to. At least once a week I get asked by the DBA's what on earth I am doing.
23 votes -
Save previous search settings.
Save all of the previous search settings for dropdowns, checkboxes and search text. Keep SQL Search tab open on next launch of SSMS.
23 votes -
I just started using SQL search and the tool is able to find words I filter by however I have scroll through lines of code in my results to
I just started using SQL search and the tool is able to find words I filter by however I have scroll through lines of code in my results to see the high lighted word I specified.Can you enhance the SQL Data Search feature to return only the highlighted line of code in my SQL search versus returning the whole script.
22 votes -
Export result set to SQL script
It would be useful to be able to export result set of SQL Search to a SQL script file (or any other format).
22 votes -
Exact Match
Please could you put the "Exact Match" feature back, it was very useful.
22 votes -
Multiple server search
Fill searcheable servers from "Registered Servers" as well as Object Explorer and allow multiple server search simutaneously.
21 votes -
Add GUI options to Add/Remove columns from search
It would be nice to have the option to show or hide some of the different columns in our search results. I rarely ever need to see the "Schema" or "Detail" columns in the search results. They are just real estate wasting columns for me 95% of the time I'm using SQL Search so it would be awesome if I could hide those for when I want to dock the SQL Search under the properties or object explorer panels.
20 votes -
In SQL Search, provide the ability to exclude searching in comments for specified text
Periodically I'll search stored procedure and functions for specific text and I'll get a lot of hits, only to discover that the hit was on a comment.
For example if we're trying to remove a specific piece of code from all stored procedures, a DBA may make a comment "Removed XXX from stored procedure". Providing the ability to "Not search in comments" would provide a true list of areas that contain the offending code.
19 votes -
Export list of objects results in a search, to txt file o allow copy to clipboard the column with the objects name.
Export list of objects results in a search, to txt file o allow copy to clipboard the column with the objects name.
18 votes -
Please provide "Check For Update" option for "SQL Search" in its help menu separately
Please provide "Check For Update" option for "SQL Search" in its help menu separately
18 votes -
Start search at button press
Search start - please make it at button press. The current "automatic" start might be annoying, especially when a very long search starts automatically after the input fileds are touched/leaved.
18 votes -
Stop indexing/searching
Sometimes when server is changed it automatically starts Reindex for all databases. Even if one database was selected later, it continue re-indexing and it could be very long. Is it possible to add Stop Reindex button to stop the process?
16 votes
- Don't see your idea?