Searching for names that contain a space

A free Management Studio add-in to search for SQL in your databases

Searching for names that contain a space

Postby Liz.Cooper » Tue Aug 19, 2014 12:02 pm

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
Liz.Cooper
 
Posts: 5
Joined: Tue Aug 19, 2014 11:58 am
Location: Cirencester

Postby mc1brew » Thu Aug 21, 2014 8:00 pm

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.
mc1brew
 
Posts: 2
Joined: Thu Aug 21, 2014 7:21 pm

Postby RickyR » Thu Aug 21, 2014 10:37 pm

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
RickyR
 
Posts: 52
Joined: Thu Aug 21, 2014 5:34 pm

Postby Liz.Cooper » Fri Aug 22, 2014 7:54 am

Exact match does work, thank you
Liz.Cooper
 
Posts: 5
Joined: Tue Aug 19, 2014 11:58 am
Location: Cirencester

Re: Searching for names that contain a space

Postby cnovac » Thu Feb 12, 2015 7:29 pm

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.
cnovac
 
Posts: 3
Joined: Thu Feb 12, 2015 7:25 pm

Re: Searching for names that contain a space

Postby Liz.Cooper » Fri Feb 13, 2015 1:05 pm

This does work for me. However maybe you have a tab instead of a space? I am on V2.0.1.36
Liz.Cooper
 
Posts: 5
Joined: Tue Aug 19, 2014 11:58 am
Location: Cirencester

Re: Searching for names that contain a space

Postby cnovac » Fri Feb 13, 2015 4:00 pm

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.
cnovac
 
Posts: 3
Joined: Thu Feb 12, 2015 7:25 pm

Re: Searching for names that contain a space

Postby Liz.Cooper » Fri Feb 13, 2015 4:03 pm

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.
Liz.Cooper
 
Posts: 5
Joined: Tue Aug 19, 2014 11:58 am
Location: Cirencester

Re: Searching for names that contain a space

Postby cnovac » Tue Feb 17, 2015 8:28 pm

Hi, how can I file this with support at Redgate? Thanks.
cnovac
 
Posts: 3
Joined: Thu Feb 12, 2015 7:25 pm

Re: Searching for names that contain a space

Postby Liz.Cooper » Thu Feb 19, 2015 9:09 am

Liz.Cooper
 
Posts: 5
Joined: Tue Aug 19, 2014 11:58 am
Location: Cirencester


Return to SQL Search 2

Who is online

Users browsing this forum: No registered users and 0 guests

cron