View Complete Post
How can i prevent author's name to appear in search results. shows many results when i search the "author.name".
I want, MOSS 2007 Search get results from the content only the user sees.
I have installed, uninstalled and installed again MS-SQL 2008 Enterprise on my system. The installation seems to go OK. I used "Select ALL" when I was choosing which components to add. I saw "FullText Search" in that list and it WAS checked for installation.
I'm going through one of those Training Kits (70-433) and I need to install the example databases. One of them "AdventureWorks" requires Full Text Search to install.
I can see "SQL Server FullText Search" in the list of services on my control panel. It's startup type is "Automatic" but it is NOT started. I attempt to start it and I get a message window saying the it could not start it: "Error 3: The system cannot find
the specified path."
When I select the FullText Search and look at its Properties, under the "General Tab", I find that the "Path to Executable" is completely empty.
I have no idea what the command line string should look like or even what the name of the execuatble should be.
I have been rooting through the WEB looking for solutions to this problem. One forum I read said that the file name that I am looking for is MSFTESQL.EXE. I have searched my entire harddrive. That files is NOT THERE. I DID find a file called MSFTE.EXE.
This has been going one for some time. I h
ALTER PROCEDURE [dbo].[SP_SearchTopics]
@keywords varchar(512) = '""'
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT t.*, FTT_T.RANK as 'Rank'
FROM Topic t
INNER JOIN FREETEXTTABLE(Topic, [Name], @keywords) as FTT_T ON t.ID = FTT_T.[KEY]
ORDER BY 'Rank' DESC
When I run sqlmetal on my database, I get this error:
Warning : SQM1014: Unable to extract stored procedure 'dbo.SP_SearchPosts' from SqlServer. Null or empty full-text predicate.
I tried checking the @keywords parameter for null and empty string, but that doesn't work. Any ideas guys?
I have a problem with full text search. It runs very slow. Originaly I thought that our server doesn't have enough memory to cache full text catalog and has to read it from the disk every time. But I ran single containstable statement on the server and it
returned results instantly. So I guess the problem is in joining containstable results with other tables, Views. I understand that containstable runs separately and the query is passed to MS Search Engine which returns results to SQL and merges them
with the rest of the query. But I am not able to figure out what exactly causes the entire query to slow down. I also noticed that Order By rank desc slows down performance even further. But I need to show most relevant results first. Also, similar query without
containstable works quite well. Below is the simplified version of my query along with the execution plan. Please help me to understand/solve this problem. We have SQL 2005 Workgroup edition, Windows 2003 server Standard edition. 4GB ram. Database size
55GB. Full text catalog size 600 Mb.
select top 60
rn = ROW_NUMBER() OVER (ORDER BY key_tbl.rank desc),
productslocation_pid, min(ProductsLocation_price) minprice,
max(ProductsLocation_price) maxprice, count(*) BCNT, rank
from containstable (products, txtcat, 'video') as key_tbl
Issue Description : Keywords from certain folders in the Document Library is not searchable via full text search. For example, the keyword
“4MB7106” is not searchable, even though the document is available in the document library. This is content search in a file in a document library, NOT a file name. Any ideas?
I have a website (asp.net 3.5+c# +linq ) having thopition to change languages (2) by the user, Am using the search engine like in the example of:http://www.codeproject.com/KB/applications/SearchDotnet.aspx this search will find any searched word in all the pages and return the link in the default language of the site, but problem for the second language , because by default the site language is English and the user have the option to change to other language.and as I understood that the .resx files can not be searched like the aspx by the search engines.I looked in many blogs and discussion boards for similar case but unfortunately no clues on this issue .The only same case posted :http://forums.asp.net/p/1523698/3669127.aspx#3669127and
also I could not find any clue to move on,
Kindly requsted to guide me for the soultio Thanks for your time and wish you all the bestyour help is always appreciated
any idea how to do that ?
Thnx in advance