BUG: Does not find all references of the searched text

A free Management Studio add-in to search for SQL in your databases

BUG: Does not find all references of the searched text

Postby LAJ » Mon Mar 22, 2010 3:36 pm


I'm currently facing the following issue:

When doing a search using the exact match on all objects I'm getting much fewer results than what I should have.

When comparing with a different search tool (toad for instance) on the same objects, toad get all the references whereas SQL Search only has a few (the count is different).

Toad get more than 150 hits (which are all valid, which mean the searched text is found somewhere inside the object code)
SQL Search get only 14 hits for which some are valid, some invalid (the searched text is not found in the source code of the result hit)

The searched text look like: "SchemaName.TableName space". (The final space is needed because some table name extend other table name therefore when adding a space I get the base table name. Ex: TableName and TableNameWithOtherCharacteristics. So looking for TableName with a space discard other table (TableNameWithOtherCharacteristics) which contain the base table name)

Some post might suggest that a dot might cause unexpected results.

The installed version of SQL Search is
I'm using SQL Server 2008 SP1

I've notice a private build but I prefer waiting for an official release before testing.

Please let me know how to fix these search behavior.

Thank you
Posts: 1
Joined: Mon Mar 22, 2010 3:22 pm

Postby emoreau » Tue Mar 23, 2010 11:49 am

this problem has been reported many times. check http://www.red-gate.com/messageboard/vi ... hp?t=10418 for a status
Posts: 38
Joined: Tue May 23, 2006 5:48 pm

Return to SQL Search Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests