How can we help you today? How can we help you today?

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.
TomSQL
0

Comments

2 comments

Sort by
  • Eddie D
    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 D
    0
  • TomSQL
    Looks like I needed to re-index the database.

    Thanks.
    TomSQL
    0

Add comment

Please sign in to leave a comment.