Issue searching for objects with underscores in the name

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.

Answers

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • TomSQLTomSQL Posts: 3 Bronze 1
    edited February 2, 2018 5:37PM
    Looks like I needed to re-index the database.

    Thanks.
Sign In or Register to comment.