20 results found
It's linked to other questions/requests, but slightly different. I would personally rather that indexing results were persisted between sessions and then updated in the background. As things stand, I have to wait around 3 minutes every time I want to search for something, which disrupts the workflow. I would much rather put up with cached results that were displayed immediately, whilst being refined in the background.
You could also use some more advanced operators (eg '-' for exclusions etc)1 vote
Provide column options. For example, searching tables for a specific field like zip code - data type shows where joins could be an issue
Provide column options. For example, searching tables for a specific field like zip code - data type would show where joins could be an issue if some are Float and others are Varchar1 vote
When Object Types: Jobs can you add something in Matches on Enabled Job and Scheduled Job ?1 vote
Allow me to explain by examples.
I enter the search term 'test' (without the apostrophes) and I DO NOT check the 'match whole words only' option. I get the following hits:
So far so good, all hits are as expected.
I then enter the search term 'test' (without the apostrophes) and I CHECK the 'match whole words only' option. I get the following hits:
And that's it. I do not get the following hits:
- dbo.test…3 votes
Currently its impossible to see User Defined Table Types at all in SQL Search. Please add this functionality. Other 'Type' objects would also be great.
It breaks your flow when rather than using search, you have to manually navigate down the object explorer4 votes
sql search stil greyed out, when do you fix this before asking for new features make the old one run well
sql search stil greyed out, when do you fix this before asking for new features make the old one run well1 vote
Would be good that SQL Search authenticated through Azure Active Directory - Universal with MFA.
SQL Search version: 126.96.36.19967
 ERROR RedGate.SQLSearch.Addin.Tab.DatabaseConnector - Could not load database list
System.Data.SqlClient.SqlException (0x80131904): Cannot open server "XXXXX" requested by the login. The login failed.
...at RedGate.SQLSearch.Addin.Tab.DatabaseConnector.OnlineDatabasesForInstance(String connectionString)
 ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy
Exception: Exception has been thrown by the target of an invocation.
...at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler)58 votes
It would be great if you could attach to an SSAS server and search the databases (cubes) for text. I'm mainly interested in the queries used to populate the tables, but I could see it being useful to search for text anywhere in the database.3 votes
If an SSIS Catalog is chosen as a database, search the SSIS packages within for the text. I'm not sure how easy it would be to show the results, but even if the results were shown in the XML file format that would be better than nothing.4 votes
column: database_name2 votes
Include the possibility to search inside table extended properties, for example if there's a description I would like to be able to find the text inside the description3 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
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
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
Do not start indexing automatically but let user to start it.
Our two database servers contain many databases. When I switch from one to another, the index is automatically started with the database dropdown box selected all databases as default. It crashes my SSMS a few times or when it did not crash, I need to wait long time to wait it to finish the indexing.72 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
Looking up any value in any DB, returns Tables/Columns/Rows in any DB per any value that you inputted
Looking up any values in any DB with the brute force approach.
--This feature will look at every table and every column for a string, number, or datetime value, etc
--It supports begins with, ends with, and contains for strings and returns a query of results
--including the count of total matches on the table and the sql needed to query that result up.
--It's also support multiple options like contains, begins with, ends with, and exact match.
--Secondly it also supports number and date searches, xml etc.
I have already implemented above features with a stored procedure, and hope…52 votes
Give the users the ability to set default databases to search in, so that when ever the SQL Search is done, it saves them the time to select their mostly searched databases96 votes
Fill searcheable servers from "Registered Servers" as well as Object Explorer and allow multiple server search simutaneously.21 votes
- Don't see your idea?