Hello All, Please explain this Fulltext behavior to me. We have an asp application that is using sql that returns the above error when you search for the word can't. If you search for "don't" or "Doesn't" or pretty much anything else with an apostrophe, results are returned. The same t...more >>

Hi, I am using SQLDMO in my application to create data tables, full-text catalogs and jobs to populate the catalogs. My datatables are created successfully but I get error on line where it says : Dim oSQLServer as SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServer I have added reference...more >>

Hi, I'm having a noise word problem that I don't seem to see in any of the other postings. Here is the setup: SQL Server 2000 Standard Edition SP3 running on Win 2003 Server. In order to avoid the normal noise word problems we edited the noise word file for english by just putting a space in...more >>

Hi, My app (VB.NET, .NET Framework 1.1) intalls database tables for a database. Then it is supposed to create full-text catalogs. It works well on my machine but not on another machine. here is error message I get: An unhandled exception of type 'System.Runtime.InteropServices.COMExcepti...more >>

Hi, Consider the following xml snippet that's being kept as an image datatype within the Sql Server 2000 SP3 running under a W2K Advanced Server machine: ....Removed For Breviry... <Sal d2p1:Beginning="2005-07-30T14:46:24.7330000+04:30" d2p1:Finishing="2005-07-30T14:46:42.9230000+04:30">...more >>

Hello All, We implement the wild card search using 'Contains' in full Text Search. However the search with the word portion within the word could not be achieved In otherwords if I seach with the key word 'plan' the test result should include the record having the word 'Testplan'. Is this po...more >>

When comparing results of SQL's Full-Text Catalog to the IIS 6.0 Index Server to ANY other commercially available vendor's offerings, like a Lexus-Nexus search or Imceda Software or DeiselWorks, which produces the fastest indexing and the fastest query results for multi-word searches across a d...more >>

I have a table with the fileds empid,empname,designation,branch.. etc I have 5 types of designations CEO,BM,PL,Tester,and PRG and the two branches those are Hyderabad and Visakhapatnam i need the query like first CEO name next Hyderabad BM Name next Hyderabad PL name next Hyderabad Testername ...more >>

Hello: running SQL2000 SP3 (8.00.818) first 1) when we upgraded our hardware, ie,rebuilt SQL on a new machine, we noticed several system stored procedures were missing, including, master..sp_fulltext_table --I found a copy on our test machine and transfered it to production server where i...more >>

When using Microsoft Index Server file system catalogs, the Index Server generates 'abstracts' which give the user an 'at a glance' indication of the entry contents. Does Full-Text Indexing within SQL Server provide such abstracts? I am developing a search facility for a web site where I w...more >>

Hi, I'm currently writing a search system in ASP with Javascript connected in to SQL to search a product database. I'm using the FreeTextTable command to search a number of fields and bring back results in rank order which is working fine. However when the user submits a word in the noise l...more >>

I have a problem whith knowing what is inside catalog, especially words that are indexed in tables. I want to improve some search capabilities, and I need to know structure of index (catalog). My improvements will probably be approximate string matching, by word distance, and I need to know se...more >>

Hi all, No BUILTIN\ADMINISTRATORS has not been removed or altered :> We aquired a new box to replace an existing server that was out of warranty. Working with the developers we have gradually moved all the databases from the old box to the new box and everything was working fine. Until ...more >>

I'm trying to use the new cidump tool of SQL Server 2005 Beta 2 to get a words list from a full text catalog and I can't find good documentation. I've looked everywhere. Have you see it? Can the SQL documentation team be so kind and provide us with something here about this new feature? ...more >>

Hi, I am using the June CTP release of SQL Server 2005 on Windows Sever 2003. Is there a quick way to get a total natch count (estimate is OK) of a SQL FullText query? I am working with about 10 million r ows of simple character data. The following SQL simply returns too slow due to disk ...more >>

I have a CONTAINS search on a full-text index and I'm having trouble running it on multiple terms without using an operator like AND or OR. Here is my search query: SELECT id FROM table1 WHERE CONTAINS(column1,@keywords) These work as they should: declare @keywords varchar(25) s...more >>

I am getting the same number of records resulting from this search, regardless of the use of the operators "AND" and "OR" All three of these yield the same results: declare @keywords varchar(25) set @keywords = ' "word1 and word2" ' declare @keywords varchar(25) set @keywords = ' "word1...more >>

Hi all - sorry if this is a 'bozo' question, I'm just evaluating use of SQL for full text indexing against other indexing systems, so just starting to get into it. Ideally I'd like SQL to maintain an index on a large amount of text, but after indexing I don't need the text to be in the databas...more >>

We are developing a Content Management System using both SQL Server 2000 and file system as repository. The files (content) are stored on disk and addition properties are stored in an SQL Server database. We'd like to provide Search functionality on both: the content of the files and its pr...more >>

1> how to select 3rd maximim salary from employee table which contains empid,name,salary. 2> how to select duplicates from a table which doesnt have primary key *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi, I have created a db install app that will install all datatables, build full-text catalogs and add job scheduler to populate the catalogs several times a day. However, I would also like my catalogs to be rebuilt every midnight and repopulated again. I know of Rebuild method and Start m...more >>

Hello, Is it possible to know status of FTS index on value in some column of row, I mean, how can I know FTS index have been updated already or haven't ?? For example, value of some row has been changed, but FTS index hasn't been changed yet. I need to know when after value updating I can...more >>

My FTIs are stuck in 'Paused' status - any ideas welcome as to why and what I should do about it? ...more >>

Hi, I am writing some code in VB.NET and need to pass an SQLServer object to a method. How do I do that? What is the type of SQLServer object? I created it using : Dim oSQLServer = CreateObject("SQLDMO.SQLServer") and want to pass it to a method like: Call CreateFullTextCatalogs(byval ...more >>

Hello everyone, I use full text search using containstable for search on my intranet site. Its been working wonderfully. However, I have recently been working on an upgrade to my search page to allow users to exclude words. When excluding words I use the "and not" operator. I have noticed...more >>

Hello I have a problem with Full Text Search and Sharepoint. From my understanding Sharepoint basically uses SQL's full text search right. But recently, sharepoint search stopped working. It's not returning any results at all. So I researched about it and found out that I should check the ...more >>

I'm using a full text index to search organization names. My language word breaker is French (France). My situation is that if I search for example for a organization with the word "meilleur" in the name ("meilleur" means "greatest" in english), the answer that the search will give me (usin...more >>

I would like to know if I can change the location of a noise file on a per-database (or filegroup) level? My situation is this: I have two databases operating on the same machine, same language, same instance, different file groups. I have one application (using one of the databases) that...more >>

Hi, I am building a database install aplication that among all other stuff, creates and populates full-text catalogs for my database. All this is done in VB.net and SQL Server 2003 My application works fine, here is the come sample: oSQLServer = CreateObject("SQLDMO.SQLServer") oSQLSer...more >>

I'm not sure how I can best phrase this, but I need help writing a query that is inflectional, thesaurus and non word ordered specific. In other words, say a user is looking for a "car wash" but types in "wash auto" or "auto wash" or "vehicle wash" or "cars washed" or "washing cars" or "car an...more >>

I cannot build ft catalog on one of my servers because of error: (1 row(s) affected) Server: Msg 7619, Level 16, State 1, Procedure sp_fulltext_database, Line 46 Execution of a full-text operation failed. The parameter is incorrect. On the second server - no problem. ? ...more >>

Hi! I'm using FTS in MSSQL2000. 1. i have a string "bcd" and i want the results : "abcd" or "1bcd" but not "bcda" or "aabcd" (always from the second letter). 2. the search column is a long string. the begining of the string is more important that the end. i want the results found in the b...more >>

Hi, I am writing a database install application that will also create full-text catalogs on specified data tables. Thanks to help I got here, this works just fine. I would also like to store these catalogs to a location different than default provided by SQL Server. I can retrieve catalog...more >>

Hello, Is there anyway to embed tags that use puctuation into a coulmn of an FTS table and be able to serach for these tags using the Contains predicate? For example, I would like to add the tag,"CDL=Y", to a column and search for this value using the Contains predicate. I'm not sure how ...more >>

Hello group, Does anyone know how near a word needs to be to another word to be included in the results of a CONTAINS search that uses NEAR? Is this setting adjustable? Is is stored in the registry? INI or config file? I'm using SQL Server 7 SP3. Thanks, Kelly Greer KellyGreer1@nospam.c...more >>

Hi, I am running Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4) on Windows 2000 Server. I have created a full text index that contains 2 tables. Th...more >>