Hi,

I want to be able to do a Full-Text search against two tables that are 
in different databases.

I have done a ranked search before using...

SELECT TOP 100 PERCENT ct.RANK, e.ContentID, e.ShortTitle, e.LongTitle, 
e.Summary
FROM CONTAINSTABLE(Content, *, '" + searchText + "') ct
INNER JOIN Content e ON ct.[KEY] = e.ContentID
INNER JOIN ContentRoles ON e.ContentID = ContentRoles.ContentID 
WHERE (ContentRoles.RoleID = 1)

Is there any way to combine and rank the results of searching with the 
same search word/phrase against two tables in two separate databases?


Cheers,

Julian Voelcker
The Virtual World (UK) Limited
Cirencester, United Kingdom