132 results found
-
Option to search tables with records only (many of my tables are empty.)
I would like to be able to check a box to eliminate any tables with no records in them.
5 votes -
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 -
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 -
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 -
Allow searching for users
SQL Search does not return users as part of the returned results. This could be useful when searching in multiple databases.
1 vote -
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 -
Exclude expression in search
Feature to exclude expression in the search.
Example:
Search by "Test", but exclude finds where "Test" is part of "tbl_Test"1 vote -
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 -
Add quick "Go To Object" like SqlSmash
SQLSmash (http://www.sqlsmash.com) has a wonderful "Go To Object" tool that I use regularly. It helps me navigate to SQL objects quickly without having to point and click. All I have to do is type CTRL+, and start typing the name of the object. It will filter the names based on what I type, and when I click enter it will select the object in Object Explorer.
It is much better at finding tables, views, & stored procs on the fly than SQL Search. It is especially helpful when working in multiple databases simultaneously. I had previously posted this…
9 votes -
Allow to search Azure Managed Instances
Allow to search Azure Managed Instances
10 votes -
make bottom panel markdown friendly for tables
When you are looking at table in the bottom panel, it would be nice if you changed the columns and rows ever so slightly. Instead of making the single dash continuous but made the two horizontal lines continuous instead, then, when you copy and paste this into a Markdown file, it will format it properly
Example
from...
[dbo].[foo]
Column | Datatype | Computed value
Id | int |
...to...
[dbo].[foo]
Column | Datatype | Computed value
----------------------|-------------------|-------
Id | int |
...1 vote -
1 vote
-
Search indexes
Please add the ability to search indexes.
9 votes -
Allow reordering of result columns
I wish to view the result columns hierarchically: Database -> Schema - > Object. But at present I'm limited to the existing order, which is reverse in my mind: Object -> Schema - > Database. Bonus if the columns are draggable.
6 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 -
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 -
Execute option for Stored Procedures.
Similar to Select Object in explorer. It would select the object and either execute it or create the Execute to New Query in Editor Window. Like the two options available by right clicking the stored procedure from the object explorer.
1 vote -
Script all matching objects
Once you have a list of all matching objects, have the option to select them all and script them to a new window.
4 votes
- Don't see your idea?