21 results found
-
Add a script to Alter for Stored procedures found in SQL Search.
Add a option when you right click on the stored procedure you found to script it to an alter page similar to how you can do that if you find a nested SP in your code.
3 votes -
Indexing Control
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 Varchar
1 vote -
enabled
When Object Types: Jobs can you add something in Matches on Enabled Job and Scheduled Job ?
1 vote -
Search option 'match whole words only' does not work as expected with database objects.
Allow me to explain by examples.
Example A:
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:
- somethinginfronttest
- testsomethingbehind
- test
- [test]
- dbo.test
- dbo.[test]
So far so good, all hits are as expected.Example B:
I then enter the search term 'test' (without the apostrophes) and I CHECK the 'match whole words only' option. I get the following hits:
- testAnd that's it. I do not get the following hits:
- somethinginfronttest
- testsomethingbehind
- [test]
- dbo.test…4 votes -
Azure Active Directory - Universal with MFA Authentication for SQL Search
Would be good that SQL Search authenticated through Azure Active Directory - Universal with MFA.
SQL Search version: 3.4.2.2567
Error log:
[78] 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 Number:40532,State:1,Class:20
[1] 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 -
User Defined Table Types in SQL Search
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.
https://forum.red-gate.com/discussion/86737/can-sql-search-show-user-defined-types
It breaks your flow when rather than using search, you have to manually navigate down the object explorer
8 votes -
1 vote
-
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 well
1 vote -
Search SSIS Packages
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 -
Search in job step's database field
table: msdb.dbo.sysjobsteps
column: database_name2 votes -
Search SSAS Cube Definitions
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 -
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 -
Search in extended properties
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 description
3 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 -
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 -
Do not start indexing automatically but let user to start it.
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 -
Ability to set default databases to search in
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 databases
96 votes
- Don't see your idea?