26 results found
-
Search for synonym base object name
Search for object that synonym is created for (select name, baseobjectname from sys.synonyms - baseobjectname)
77 votes -
73 votes
-
Include Search inside synonyms objects
SQLSearch doesn't find keywords inside Synonyms. For instance I want to find all Synonyms regarding table MyTable
48 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 -
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 -
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 -
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).
15 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 -
Copy colums from the search grid
it would be very helpful to be able to copy and paste a list of objects from the search grid rather than the whole line.
13 votes -
Filter object explorer by schema
Chose schema from combo box and all tables, view-s, procedures, functions, .... are filtered by schema in Object Explorer.
10 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 -
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 -
Search indexes
Please add the ability to search indexes.
9 votes -
search on data type
It would be nice to add a search on the data type
9 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 -
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 -
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 -
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 -
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 -
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
- Don't see your idea?