SQL Search 3.0 does not search in contained database

frm · April 2, 2018 1:32PM

If containment is set to PARTIAL SQL Search indexes the database then does not show any results for any query, if I change containment to NONE and reindex it starts to show results again

Facts:

I updated SQL Server 2016 to latest available version 13.0.4474.0
Windows Server 2016
Management Studio 14.0.17199.0
Logged in as sysadmin
SQL Search 3.0

AshaPatel · April 3, 2018 3:32PM

Hi frm,

Thank you for your post, sorry to hear you're having an issue! We released a new version of SQL Search recently which is available from this download link:

ftp://support.red-gate.com/patches/SQLSearch/29Mar2018/SQLSearch_3.1.2.1997.exe

If you update to this version are you still seeing the same problem?

Thanks,
Asha

frm · April 3, 2018 4:54PM

This version works, thanks a lot

JPP · April 7, 2018 1:13AM

Hi, can you please provide a non-FTP URL to download the new version? My FTP connectivity is blocked. Thanks.

RichardL · April 13, 2018 1:28PM

Hi @JPP

Thanks for your post.

Sure! I've uploaded it to a secure HTTP site for you and the link is below.

https://files.red-gate.com/message/0R0QC4ePhDLjehR2FGtcht

Have a good weekend.

Best

Richard Lynch.

SQL Search 3.0 does not search in contained database

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk