Issue searching for objects with underscores in the name

TomSQL · February 2, 2018 4:08PM

I'm using SQL Search 3.0.7 in SSMS 17.4.

When I search for an object with a underscore in the name, the search stops returning results as soon as I type a character after the underscore. If I'm searching for table_name, no results are returned as soon as I type table_n. Even if I type in table_name and check the exact match button, I get no results.

I couldn't find any documentation with workarounds.

Thanks.

Eddie D · February 2, 2018 4:41PM

Hi TomSQL

Thank you for your forum post.

I am unable to replicate the reported problem. If you enable the verbose logging, are there any entries in the log file that point to a cause or error?

To enable verbose logging and locate log files:
Help menu ->Logging ->Minimum Logging Level ->use drop menu to select logging level, in most cases set to verbose.
Help menu ->Logging ->Locate log files
Help menu ->Logging ->Open current log file

Many Thanks
Eddie

TomSQL · February 2, 2018 5:17PM

Looks like I needed to re-index the database.

Thanks.

Issue searching for objects with underscores in the name

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk