Searching Multiple Websites

[msdnbuddy]

Would like to know if anyone has done this in the past - Searched separate
intranet sites using Index Server.
Additional Information:
We have an existing intranet (http://oldIntranet.net) and Index Server is
used to search this intranet. Currently, we are building out a new intranet
site (http://newIntranet.com) and will use Index Server to search. The
requirement is to have Search on both sites and being able to search the
content across both the old and the new intranet.

Server/Folder information:
Both the old and the new intranet sites are hosted on the same servers.

Any ideas on how to tackle this issue would be highly appreciated.

Thanks

[WenJun Zhang[msft]]

Hi,

An index catalog can only be binded to one web site. So you'd first create
a new catalog in indexing service snap-in and bind it with the new intranet
site(in catalog properties->tracking tab). Then assume you are using ASP
based query form. The most straightforward and simple approach is to get
two record sets by executing queries on both catalog. This should be a
little bit more flexible since you know results in which recordset
corresponds to which site.

Another way is using a single union query in below format:

SELECT Path, Filename, Size, Write
FROM (TABLE foo..SCOPE() UNION ALL TABLE bar..SCOPE())
WHERE [...Conditions > follow...]

Hope the info above helps. If you have any further question, please don't
hesitate to update here to let me know.

Have a nice day.

Sincerely,

WenJun Zhang

Microsoft Online Community Support

==================================================

Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at:

http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

[WenJun Zhang[msft]]

Hi,

Just want to check if the problem has been resolved or if you have any
further question?

Thanks and have a nice weekend.

Sincerely,

WenJun Zhang

Microsoft Online Community Support

==================================================

Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at:

http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

[chris]

Hello WenJun Zhang,
Can I use classic asp to combine two recordsets. How does the programing
logic work. do I do one query first. Then do the second query and use another
loop and do the .addnew to the first recordset with then 2nd query.
Chris

Post by WenJun Zhang[msft]
Hi,
An index catalog can only be binded to one web site. So you'd first create
a new catalog in indexing service snap-in and bind it with the new intranet
site(in catalog properties->tracking tab). Then assume you are using ASP
based query form. The most straightforward and simple approach is to get
two record sets by executing queries on both catalog. This should be a
little bit more flexible since you know results in which recordset
corresponds to which site.
SELECT Path, Filename, Size, Write
FROM (TABLE foo..SCOPE() UNION ALL TABLE bar..SCOPE())
WHERE [...Conditions > follow...]
Hope the info above helps. If you have any further question, please don't
hesitate to update here to let me know.
Have a nice day.
Sincerely,
WenJun Zhang
Microsoft Online Community Support
==================================================
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.