I can't seem to get SQL Search V2 to work where a name has a space in it e.g. [Full Domain]. Any suggestions please? Using AND or % don't work either
Comments
9 comments
-
Hello Liz Cooper,
Have you tried the "exact match" check box?
Searching with a space seems to be working for me. However I feel like I've run into this before. I also reinstalled today and I am using version 2.0.1.30. Not sure if maybe they've recently made any changes.
Let me know if you find the solution to your problem. -
Hi Liz,
Thanks for your forum post!
Let's take this case off the forums and work on this offline, as it seems that we will need to do some investigation as to why this is occurring. I will be replying to you through the portal system.
Thanks!
Rick -
Exact match does work, thank you
-
Hi,
Is there a resolution for this? I'd like to search for insert into x, but exact match doesn't work and if you don't use exact match, it give hits for partial matches on insert/into/x. Thanks. -
This does work for me. However maybe you have a tab instead of a space? I am on V2.0.1.36
-
Hi, Thanks for reply. Seems to be issue with tables that have _ in the name. In my example: insert into license_attribute
As soon as you type in the underscore, the search with exact match stops working. -
Sounds like a bug there.
We have hardly any tables with underscores in their name so I can't check this for you, I'm afraid. -
Hi, how can I file this with support at Redgate? Thanks.
-
Add comment
Please sign in to leave a comment.