133 results found
-
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 -
Export result set to SQL script
It would be useful to be able to export result set of SQL Search to a SQL script file (or any other format).
22 votes -
Major KNOWN Issue --- Stop requiring product to login to all databases on server
The product requires you to have at least read access to all databases on provided server... because when the product opens... and db access is lacking... then USER is failing login attempts on PRODUCTION SERVERS to which user has no access. This creates GREAT FRUSTRATION for DBA and AUDITing groups.
32 votes -
search on data type
It would be nice to add a search on the data type
9 votes -
Stop the search once started or at least control when it "starts"
Add a stop/start button to the search process.
If you change the criteria, it immediately starts searching for that criteria before you get a chance to change some of the other parameters.
Worst case scenario it eats up all the memory and crashes SSMS if you search against "All Databases" on a production server.
Give some control back to the UI.25 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 -
Add GUI options to Add/Remove columns from search
It would be nice to have the option to show or hide some of the different columns in our search results. I rarely ever need to see the "Schema" or "Detail" columns in the search results. They are just real estate wasting columns for me 95% of the time I'm using SQL Search so it would be awesome if I could hide those for when I want to dock the SQL Search under the properties or object explorer panels.
20 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 -
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 -
73 votes
-
Show modify_date of objects
I would be great if we could see the last modify_date of the objects in the results grid and sort by last modified
14 votes -
Search through SSRS reports as an option under "All object types"
The search for through functions, store procs, views, tables is great. But it would help if one was able to search through SSRS reports as well.
This will enable one to find where functions, store procs etc. are been used. As the "Show Dependencies" is limited to a specific DB and does not have the ability to "look" into deployed reports.
7 votes -
Print List
Once the list is generated allow the printing or export of the list.
Cheers
12 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 -
I would like to see history of my search and to be able to re use it fast, right away in search box.
I would like to see history of my search and to be able to re use it fast, right away in search box. The idea is that almost all the time I’m working with 2-4 tables, SP and views and it will be helpful to me to get last 10 used search text at once. A text is selected when I do Navigate to Object function.
The list could be like combobox or like auto complete /with text that has been used already/.
I’m sure this will be in help for all persons using you great search tool. I’m using…
46 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 -
sql search remembers database filter selection for each server
when selecting a server, sql search should remember which databases on that server you last searched.
I often want to just search 5 db's on the 1 server, and re-selecting them each time i open search is annoying. (the selection gets forgotten when you search on a different search, or close the window)45 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 -
Script results so we can easily replace text/columns/code in large amounts of tables/views/sprocs and even across databases
In search result windows , multiselect is possible. On right click give option to script out selected objects.
Workaround i use for now:
What i usually do is open sql compare alongside and then select results from a single database and compare them to an empty database, script all out, and then replace create statements with alter.33 votes -
Multiple server search
Fill searcheable servers from "Registered Servers" as well as Object Explorer and allow multiple server search simutaneously.
21 votes
- Don't see your idea?