Your search for "full-text-search" returned 100 results:
I'm using CONTAINS to search for a string or word. If I search for Hobby is it possible to make it search for Hobbies also, which is the plural of Hobby? FREETEXT seems to be doing this but I want to do it with CONTAINS because it will make me search with an AND clause. […]
2013-07-26
540 reads
One of my company's testers wrote up a bug about an area in our application returning more results than expected when searching for the letter n. On further investigation, we found something quite startling -- using the fulltext CONTAINS function to match "n*" , "d*" and "t*" are matching many (but not all) records where the […]
2018-09-28
358 reads
I would like to search pdf documents stored in the database. I'm using SS2k on Windows Server 2003. I downloaded the adobe pdf IFilter v6.0 and installed it on the database server, however, the instructions for installation are meant for the Indexing Service and not the MS Search Service. I haven't tested the search yet because […]
2006-12-19
53 reads
I've created a search for my users to search the title and description and I used full text search and CONTAINS. I'd like to implement an AutoComplete keyword suggestion for my users ( like Google Suggest ). The keywords I would suggest would be keywords extracted from the title and description columns. What is the […]
2009-03-18
250 reads
Jul 4, 2006 ... This refers to the manner in which search phrases supplied in a query are expanded by the parser before hitting the full-text index. This ...
I'm having trouble setting up full text search on my database. I have been unable to create a fulltext catalog. I get the following message when I try: ======================================================== Full-Text Indexing Wizard Progress - Create full-text catalog TextCatalog (Error) Messages * Create full-text catalog failed. ------------------------------ ADDITIONAL INFORMATION: Create failed for FullTextCatalog 'TextCatalog'. (Microsoft.SqlServer.Smo) For […]
2010-11-13
135 reads
Hi,The following select select * from sys.fulltext_languagesretnurns me no rows. I have Windows XP x64 and SQL 2005 Developer version 9.00.2047.00 (X64). I have installed full text also and it is runing.Does enybody have any idea why I have no full text langueges definedRegards
2006-11-05
410 reads
Jun 25, 2018 ... I've used full text search for partial address lookups to good effect. I even indexed the numeric parts of the address. The database ...
I want to alter the datatype of a clumn text to nvarchar(MAX) of a table who has thousands of records in SQL Server 2008. I tried following ways but I was not able to change the datatype of a column. I went to the design structure of a table and changed the datatype from text […]
2008-08-28
1,437 reads
Where does FULLTEXTCATALOGPROPERTY get its information from? If you run this command SELECT dateadd (ss,FULLTEXTCATALOGPROPERTY ('word_search', 'PopulateCompletionAge'), '1/1/1990') I am getting different results on each node of my cluster (using legato). It displays the last date the full text catalog was populated on each node not the same date. This is the path of the […]
2005-01-20
133 reads
By Steve Jones
We’re taking the roadshow across the water. Hope the plane makes it. The Redgate...
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
By Steve Jones
This month is a great topic to me. I think growing and improving your...
hi all, is there anyway in SQL to getting logged in user name to...
Is there a trigger to notify when a new SQL Agent job is created/modified?
Hello I have a view based upon a number of tables I'm selecting...
In which editions can I use Full-Text and semantic search?
See possible answers