SQL Search 3

SQL Search 2.0 release notes

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 

 


Didn't find what you were looking for?