Showing posts with label full-text-search. Show all posts
Showing posts with label full-text-search. Show all posts

Sunday, February 26, 2012

Full-Text-Search

Hi friends

i work with sql server 2005 express(Management Studio)

can i use full text search service with that edition of sql server?

and how i can use that.

thank u.Smile [:)]

The Full-Text Search feature is not available in SQL Server 2005 Express.

HTH,
Ryan

|||

thank u for ur answering.

so which edition of sql server support that?

|||

fahima wrote:

so which edition of sql server support that?

The Workgroup, Standard, and Enterprise editions all support Full-text Search.

HTH,
Ryan

|||

ok

is it hard to work with service?

|||

fahima wrote:

is it hard to work with service?

Do you mean is it difficult to get Full-text Search to work? I've never played with Full-text Search, but here's an article that should give you a better understanding of it:Understanding SQL Server Full-Text Indexing.

HTH,
Ryan

|||

the Express Edition does in fact have full text search feature available. to get this you need to download a different file, SQL Server with Advance services -http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

Not sure if this was released since the last post here - just though i would answer seeing as i was floating around.

regards

Full-Text-Search

Hi,
I have a full-text search enabled table and an image data type column that stores the extracts from the documents stored in the files. I have created a full text catalog that indexes few columns in the table and image data type column as well and I assigned the extension column to this image data type column.
Everything works fine except that search on the image data type column called, in my case "body" does not return anything. The documents exist, there is an information in the "body" column.

My code goes like this:
select FT_TBL.resourceID, FT_TBL.lang, FT_TBL.keywords, FT_TBL.description, FT_TBL.extension, b.rank
from full_text_search as FT_TBL inner join containstable(full_text_search, *, 'Microsoft') as b
on b.[key] = FT_TBL.resourceID
order by b.rank desc

any help appreciated,
thanksI figured the solution to the previous post. I was trying to search on the .pdf files, but I do not have filter installed on the server to filter through these files, other files extension work fine.

Another problem:
I have two tables that are full-text search enabled. And I need to search one table first, and than the columns in the second one. This works fine if the search criteria is found in both tables, but if not the query returns nothing.

help much appreciated!
Thanks|||use union all.