Hi all, here's my setup: Sql Server 2005 on Windows Server 2003 (standard). I have a datbase (Sql 90 compatibility level). I have very trivial example set up to try to get the thesaurus to work. My table: CREATE TABLE TestData ( TestDataID int PRIMARY KEY NOT NULL IDENTITY(1, 1), T...more >>

Hi All, We are currently having some performance issues with a query that is utilizing a "Like" search with wildcards. Background: We are running SQL Server 2005 64Bit (sp1) Windows 2003 Standard 64Bit edition (sp1) PowerEdge DUAL Xeon EMT64 machine 16GB ram CX300 SAN with 10 x 140GB 1...more >>

Hello everyone I'm a Newbie to SQL and looking fro some guidence. We are building a web site that will construct a page from multiple tables in SQL. (Sounds easy so far) The question is how can I do a full text search that will includes all the information on the page not just from one table...more >>

I have an application I wrote that imports files into an image column in a table. I have fulltext search setup on that table and it works great. A problem I have is with scanned PDF documents that have not had OCR performed on them. Is there an ifilter that can perform OCR on scanned PDF docum...more >>

There are some conflicting reports about this on the web, but as best as I can tell FREETEXTTABLE includes stemming and thesaurus features but not SoundEx abilities. I would appreciate any help on using FREETEXTTABLE and SoundEx together in a query, particularly in regards to doing searches on...more >>

Assuming I decide to keep my images in the file system (and the associated text in sql), what's the best way to give access to a sql-based win app? I can't give direct access to the folder, and can't think of a nice way for sql server to deliver or accept the images. Is a web service it? Any ...more >>

I have a FTcatalog on a table called "products" where I'm indexing "product_id", "product_name", "product_description" I'm parsing a search box in a form and splitting on the spaces to dynamically create the query, so someone my type in "Bob&Roy Video" If I search for 'Bob&Roy' using conta...more >>

Hi: Quick question...I have a FT catalog populated with a table of products. The catalog contains the product_id, product_name, and product_description fields. When I write a query, like: select p.*, k.rank from products p inner join containstable(products,product_name,'isabout (firesto...more >>

In MS SQL 2005 Enterprise Evaluation I created ful-text catalog. then I created full-text index for a few tables. and after that I run select FULLTEXTCATALOGPROPERTY('FT','ItemCount') and it return 0 also I tryed to perform a search and I got 0 results.. I followed the syteps in here ; ht...more >>

SQL Server fulltext resource is deleted from SQL cluster resource. When I add resource from clusadmin tool the resource is not coming online its failing any idea why this is not coming online? its on SQL2000 and windows2000 Thanks,...more >>

-We have a 2 node windows 2003 enterprise edition cluster (S01 and S02). -2 sql servers running in 2 different virtual servers (V01 and V02). -The V01 SQL Server's preferred node is S01 and the V02 SQL Server's preferred node is S02. -On V01 one database has fulltext catalogs. -When the V01 ...more >>

Hi does anyone know how to search for Tab or other ascii characters (like carriage retrun, line feed, etc) within a string (either varchar, or text). i'm using sql 2000.. Also i was looking for some resources on Full text causing blocking on the server but can't find anything. a partial refre...more >>

Hi, I have installed SQL Server 2005 Express Edition with Advanced Services and I tried to process a full-text search on a varbinary or image column. I insert in this column ppt-files. But it returns always 0 rows, although I searched some words that are inserted in my ppt-files. On text based...more >>

In SQL Server 2005 I can use full text searching on a varbinary(max) column containing a Word document (for example). When I return the results of the search, I would like to return a snippet of the text which matched the query to give my users some idea of why that document matched. Is ther...more >>

Hi, I have some problems when searching using contains with multiple words. A exemple: I have records with keyword bell and some othe with "bell pepper" (including quotes) Is it possible to sort records with the bell only keyword before the bell peppers ? Many thanks Stephane ...more >>

We have 2 boxes running clustered windows enterprise OS 2003, SQL server 2000 sp4 in clustered mode. Everything runs fine, except when we do a failover of sql to the secondary node, full text indexing will not index. The properties come back with an item count of 1 instead of 100,000+. ...more >>

Hey Hilary, Mike from microsoft.public.sqlserver.programming told me to talk to you about my question. Here's my original post: I'm looking for some information about storing BLOBs in SQL. A bit of background: my company is developing a document management system. Previously, we had store...more >>

Hi, I am currently using the third party product "SQL Turbo" on SQL Server 2000 to archive this: I have a table: id DocText DocScore 1 foo foo 2 2 bar bar 1 .... (approx. 1 mio. entries) Now with SQL Turbo I can do something like this: select top 100 id from Exa...more >>

Hi, I have a DB where I use to store file (.doc , .ppt, etc) everythings working fine still I add .pdf file. I've Download the 6.0 IFilter from Adobe and execute the "exec sp_fulltext_service 'load_os_resources', 1 exec sp_fulltext_service 'verify_signature', 0" command on my SQL20...more >>

Hi, Is that possible I can put the MS Word document into SQL Server? If so, what data type I should use? I would also like to know how I can use the full text to search the string I want in MS Word files since I have about 20 Word files right now... Thanks so much Ed...more >>

Hi all, I´m having this error when I try to search sql server 2005 in Visual Studio 2005 / Commerce Server 2007, and I don´t know how to resolve it. I´ve alredy tried to delete, modify the Full-Text Index on my table, etc, etc, but doen´t did any difference. Any tips? "Full-text table or i...more >>

I spent some time today with FTS and ranking search results with different weights on different columns. I came up with a solution and put what I came up with on my blog but wanted to know if there's a better way or if there's an issue I'm missing. Blog post: http://www.developmentnow.com/blo...more >>

Hi, I am building a japanese/english database that will be used as a multiple-purpose dictionary. I have a table for a standard english-japanese dictionary (associates english words with their japanese translation), another one containing many pairs of japanese sentances and their english cou...more >>

It looks like several people asked basically the same question in thi forum, but there was no answer to it. The question is: what is th syntax to use another column as the search parameter with CONTAINS? I'm trying to find all records in table1.searchable_field which contai values from table2...more >>

Hello, I have a lot of experience working with SQL FTS, but not on a major scale, and a lot of the information I've seen implies that SQL FTS isn't intended to work against 1B or even hundreds of millions records. In a nutshell, is SQL 2005 Full Text Search an adequate platform for a search e...more >>

Hello, everybody! I have just one question. And I hope someone will answer me. So, I need to figure it out, how you can transfer your tables (containing data) from SQL Server 4 to SQL Server 5 that you have THE SAME language settings. Does SQL Server 5 support that? Look I am from Slovenia, so...more >>

I am running a query that looks like : select entryvalue FROM table WHERE CONTAINS(EntryValue, ' "more information" ') I get back rows like : "... wanted to know more information about ...." but the following row is also returned : "General information about what he may be entitled t...more >>