26 results found
-
Search Stored Procedure by name shows the SQL Jobs and Steps that procedure is called from
When you search for a stored procedure, it shows its name and details.
It would be helpful to know which SQL Server Jobs and steps call/execute that stored procedure. That allows me to understand the importance and extent to which that stored procedure is used.
4 votes -
FIX IT! Whole word with semicolon ending means NO HIT!
Search for a Procedure that has NO parameters, and the code-line ends with a semicolon - Search IS BLIND! What a lousy BUG!
4 votes -
When searching for a string, include a count of instances within each object within search results
When using SQL Search to find a column name within objects, it would be extremely helpful to have an additional column that totals the number of instances of that search string within the search results. Clicking on a row in the search results shows the first instance of the string within the object but if it's a stored procedure, function, trigger, table, or query it's helpful to be able to see the total number of instances of that string within the object.
Also in the object definition window, it would be really nice to be able to click a button…
4 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 -
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.
0 votes -
Add Hotkeys to SQL Search
I would like to be able to activate SQL Search from the keyboard instead of clicking the icon on the toolbar. In addition, I would like to have keystrokes to toggle some options like whether it Matches on Name, Text, or Column.
When I'm searching for objects with names containing "xyz" I'd like to do it quickly from the keyboard without having to navigate with my mouse.
This should be an easy request to fulfill and will give you points in the Accessibility category.
9 votes -
Add ability to search for identifiers (tables, columns, indexes, etc.)
There is currently no way to search for an identifier, e.g., a column name, without also matching text that contains that identifier. For example, if I want to search for a column called ExampleColumn but ignore ExampleColumn2, BadExampleColumn, etc., I could try the "Match whole words only" option. I want it to find all of these:
SELECT ExampleColumn FROM ExampleTable; SELECT ExampleColumn, OtherColumn FROM ExampleTable; SELECT [ExampleColumn] FROM ExampleTable; SELECT et.ExampleColumn FROM ExampleTable et; SELECT * FROM ExampleTable WHERE ExampleColumn=3; SELECT SUM(ExampleColumn) FROM ExampleTable;but only the first three are found. Without the whole words option, it would match all…
1 vote -
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 -
Show results for user-defined types
Enable users to search for user-defined types. Sometimes there is a certain change and SQL search will not show relevant fields of a user-defined type that matches the search criteria.
4 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 -
Foreign Keys
Please add ability to search foreign keys.
3 votes -
Search indexes
Please add the ability to search indexes.
9 votes -
should be able to search for columns with a specific columntype
should be able to search for columns with a specific columntype
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 -
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 -
Show column nullability and default value
When showing results on a table definition, show the nullability defined for it as well as any default value. Now, I see three columns: name, datatype and computed value. Please add two more: Null and Default, preferably in the order: Name, Type, Nullable, Computed, Default
6 votes -
Option to exclude disabled jobs
It would be useful to have the option to exclude disabled jobs from the search.
4 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 -
search on data type
It would be nice to add a search on the data type
9 votes -
Ability to search triggers on servers (master.sys.server_triggers)
SQL Search version 2.3 does not search name\definition in master.sys.server_triggers.
44 votes
- Don't see your idea?