What are the challenges you face when working across database platforms? Take the survey
Options

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

  • Options
    Eddie DEddie D Posts: 1,792 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
  • Options
    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.