SQL Search 2.0.1.28 - April 28th, 2014

We're pleased to announce that SQL Search 2.0 has been released. SQL Search 2 comes with new functionality including searching in jobs, searching in multiple databases and object types, searching with booleans and wildcards, and a higher search result limit.

Download SQL Search 2.0 here.

New features and improvements

• Search in jobs.
• Select multiple object types and databases to search in.
• Improved reliability of search results.
• Improved indexing.
• Reindexing is now a single option, with a keyboard shortcut Ctrl+Alt+D (bug SDI-201).
• Search results limit is raised to 500 results per database, with the option to see all results for a particular search.
• Banner ads removed.
• Cleaner design.
• Search with % wildcard.
• Search with Boolean operators.
  Can search with AND or OR, with a single NOT clause at the end of a search.
• A text preview of matches on column names is available.
• SSMS 2014 support

Fixes

• SDI-91, SDI-92, SDI-115 - Delay on typing and search result limit allows initial quick searches on large databases.
• SDI-97 - Dragging the columns across the empty results pane no longer distorts the help text.
• SDI-147 - SQL Search toolbar now remembers position.
• SDI-155 - Results are shown for partially typed names.
• SDI-174 - Objects are found by their current names.
• SDI-149, SDI-183, SDI-188, SDI-196, SDI-552, SDI-559 - Can search for literal ", $, _, *, = characters, and preview will highlight and scroll.
• SDI-199 - Search result limit is now clear in the UI.
• SDI-200 - SSMS 2005's default databases for a connection is now recognized.
• SDI-410 - No longer repeatedly reindexes during searching.
• SDI-430 - No longer crashes SSMS when an XML document is open.
• SDI-442 - Can now find procedures after reconnecting.
• SDI-459 - Can now find objects if the search term is split across two rows in syscomments table.
• SDI-461, SDI-467, SDI-473 - Autobugs fixed by migration to the SIP Framework.
• SDI-522 - User profiles folders with accents in the name can be found.
• SDI-535 - Can now copy search results when an unsaved document is open.
  See the troubleshooting page Unsaved documents cannot be cut or copied to the clipboard from the Miscellaneous Files project.
• SDI-553 - Objects filter is more reliable.
• SDI-544, SDI-557 - Reindexing is more reliable.
• SDI-609 - Changing the search term during a long search no longer returns incorrect results.

Known issues

• SDI-570 - When exact match is on, partial matches are still highlighted in the preview window.
• SDI-611 - Using the Ctrl+Alt+D shortcut causes selected database to change to the database context of the last open query.
• SDI-615 - Matches on Unicode substrings in object body text are not highlighted.

SQL Search 2.0.1.30 - May 20th, 2014

Fixes

• Avoid clashes with other tools depending on the SSMS Integration Pack

SQL Search 2.0.1.36 - December 4th, 2014

Fixes

• Fixes bug where sometimes SQL Search didn't scroll to the result's position

SQL Search 2.0.1.53 - February 24th, 2015

Fixes

• SDI-583 - Crash when SQL Search has been disconnected from the SQL Server