Hi, I want to run this within my sotred procedure: EXEC SP_FULLTEXT_TABLE @tabname='DocumentTable', @action='start_full' Such that an authorized user can connect to database, and run this stored procedure to initiate a rebuild of index. The problem is I get an exception in my C# code wh...more >>

i get this error when there is even a single noise word in the search clause, the solution people have proposed are , and which dont work under my sitiuation 1> i can write procedures to delete the noise word file application is a deployable application, can be deployed by people on shar...more >>

(SQL Server 2000, SP3) Hello all! We've got an issue with a Full Text Search query that is failing because of too many search terms in the CONTAINSTABLE clause (upwards of 3000 elements separated with " OR ", I think). I was wondering if the CONTAINSTABLE clause could somehow be refactore...more >>

Can CONTAINSTABLE query a value in one column AND a value in another column? As an example, i have one table (Names) with three columns, staffid (int), firstname and lastname (varchar). I have created a full text catalog on this table (on the first/lastname columns). There is one row, staffid (1...more >>

I have a varchar field which typically has about 200 characters of text in it. I need to extract a particular set of characters from it, which appear at different location in the text. The characters I want always have certain text before and after them. Is there any TSQL command which will ...more >>

I have been able to use command line to import images from network into database tables sucessful. But when I use store procedure to import images from network I got the following error message: "Problem with file '\\Wd-syd- 15024\E_Books\s.jpg' " The store procedure is: CREATE PROCEDURE s...more >>

sql2k sp3 Hello all. I populating my first full text catalog. The column that Im doing it on is indexed. The table has 750,000 rows. The population has been running for 4 hours now. Looking at the properties, the item count is at about 350,000. Im definately not on the fastest box in the ...more >>

iam assuming this could be a trivial issue, but some how iam not able to find it is there a way to check from a sql script whether mssearch service is running for a partcular database thanks -ashish ...more >>

Hi all, I'm using an FT index to perform searches on tables with data in several languages. My problem is that the FT engine does't break a word like "l'Italia" (w/o quotes) in 2 words, this is very annoying and produces wrong results. Is there a way to add new word breaking characters? ...more >>

Hello, I am using Contains statement in combination with FORMSOF (INFLECTIONAL, word) I filter all the ignored words that are in noise.eng file before I create my search statements. The problem is that by using FORMSOF (INFLECTIONAL, word) statement the words like "made" or "liked" are now ...more >>

hi all, iam new to full text indexing world, iam planning to write a stored procedure using contains clause on the queries because of obvious reasons, although i have some concerns, any pointers or help would be highly appreciated 1> will the full text indexing service impose a significan...more >>

Is there a way to only perform a full-text search on a result set. select top 500 * from loren where date_time_stamp >= '20031101' and contains (*,'navy*') and contains (*,'energy*') I want to perform full-text query only on those records that meet the date_time_stamp crite...more >>

I have a table in which I am storing various office documents (Word, Excel, etc.) When I issue a query against the indexed column, I get results, but not what I was expecting. What I expected to see was something similar to the results you get when you query against Index Server; i.e., the searc...more >>

Hello, I've tried to complete the SQL Server full-text indexing wizard, so I can use 'contains' in my queries. But every time I try to complete the wizard and it actually tries to start creating the indexing table, I get the message: 'The Microsoft search service cannot be administered under ...more >>

Hi, does any of you know how to use the .NET class Microsoft.SharePoint.Portal.Search.QueryProvider to query the SharePoint searchengine? The Microsoft SDK documentation states the following about the QueryProvider.Execute(string) method: "The Execute method executes Microsoft SQL ...more >>

Hi, i have created a table with image-column. In this column i have inserted doc, xls, ppt, html and pdf files. The fulltextindex for this column is created. I want to search a single wort "news" in this image-column. But i get always also the documents, in which contain the words "newspaper", "ne...more >>