I would like to perform a search for a string (for example "0021-899-1234") that could reside in any table within a given database. (I performed a massive change and I would like to spot check to ensure that I got all occurrences of the proper columns.) Is there as easy way to set-up th...more >>

We use fulltext search on a MS SQL 2000 SP2 server. When a user that have administrator permissions on the server makes a search everything goes well, but when a non administrator user searches he gets a timout. (Microsoft OLE DB Provider for SQL Server) Timeout expiredError Code: 0x80040...more >>

Hello folks, I have a table with several FT-enabled varchar columns, in SQL Server 2000. If I ask for SELECT * FROM tbl WHERE CONTAINS(*, SearchStringA) I get several rows. (as expected) If I ask SELECT * FROM tbl WHERE CONTAINS(*, SearchStringB) I also get several rows and they ar...more >>

I receive a 7619 error message when I run a full text query that contains certain Turkish character strings on an instance of SQL Server 2000 that is running on a Windows 2000-based computer. How can I solve this problem? ...more >>

Hi, Is there a way to programmatically determine (perhaps by interrogating the system catalogs) if a column supports full-text searching. In my application I want to use "CONTAINS" where support is available but deprecate to "LIKE" where it is not. TIA Robin ...more >>

Hi I have just installed Sql server 2000 developer edition (mixed mode auth) and have installed and started the Microsoft Search Service (which runs under the local system account) However the Full-Text indexing option is grayed out? I have another development machine which is set up using th...more >>

I want to search for a substring that is contained in one of the indexed words. For example, the catalog contains "00001498ABC" I want to search for the substring "1489" since I don't know what the leading characters are going to be, in this case four leading zeros. I know the asterisk can be u...more >>

I build FT catalog for my database which has 10GB size. Catalog wa built and populated ok But our customer has the same database (120 GB) and I run populatio and two weeks I see 'Paused', 'Recovering' and so on. FT Catalo does not finish populating Server machine has 2 CPU 3000 GHz, 6G RAM, Wi...more >>

Been reading thru all the posts and KB's on dealing with searching across multiple columns. Most examples indicate you know what you're looking for in each column. Here's my big problem: A: I have 12 tables, each with multiple columns that need to be searched. B: User will enter a searc...more >>

Hi , i am using a very long query in a containstable predicate with an isabout search method. somthing like this :CONTAINSTABLE( dbo.TBL_FTS_DATA,FreeTextDump, 'ISABOUT(..... my problem is that when my' ISABOUT is more then 8000 chars long the query fails. it seems that the isabout p...more >>

Hello everyone, I have a large table (around 15m rows) I'm trying to Full-Text index using the Japanese wordbreaker. When I do a full process, after processing 3-4 million rows, I see a couple of "Error Fetching URL (80070006 - Invalid handle)" records in the Gather Log, followed by many...more >>

hi, I'm using SQL Server to store files in image column (blob). Previuosly I Used 'Index Server' with FileSystem To Search text in the files by doing this i could retrieve special column like DocAuthor,Content, ... I didn't find a way to do the same in SQL Server Full Text Search to retrieve t...more >>

Hi, I´m have problems with FTS used by CS and SPS. I saw a article 308797 that requires a support pack. How can I obtain this support pack until I test a SP4 for verify if this problem fix in Service Pack. http://support.microsoft.com/default.aspx?scid=kb;en-us;308797 Error: Even...more >>

Anyone come across this event id? I have a problem saving an XML document from Infopath to a Sharepoint form library. After I submit the form I get an error message 'File in use by another application or user' error. Event Type: Information Event Source: SQLFTHNDLR Event Category: None E...more >>

Hello, Our main product catalog is approx. 3.1 million rows, with a full-text index on 3 (varchar) columns. For the past year as our catalog has grown, we have experienced continuing performance degredation, to the point that we are looking at biting the bullet and migrating this application to...more >>

On the SQLServer SP3 my stored procedure worked fine. I have install SP4 and rebuild FT catalogs. I dont delete and create new, but only rebuild. Now for example, I entered word 'putin' and 'rasputin' into table with ft indexed column. Stored procedure found word 'putin' 1.select * from...more >>

Ok, why are my indices all paused? Ran out of diskspace the other day. Stopped the Service, moved the indices to another drive (had a little problem with 1-2 of them which I believe I've fixed.) Have restarted, and every full text index on the machine, including one in a different DB is in...more >>

How can I get a block of text into an ntext field. Have tried copy and paste out of Notepad into field in Enterprise Manager? But it truncates. Is there a command line that will put text into specific field in specific table? ...more >>

Hillary, would you mind doing a small explanation on this post? Thanks a lot! It will do a clustered index scan. this is what it looks like. StmtText ---------------------------------------------------------------------------- ------------------------- SELECT * from authors WHERE ...more >>

If I have a table with a Full Text Search and I do a Full Re-Population; What happens if someone does a Search while it is doing a Full Repopulation? Is the search delayed until the repopulation is done, does it only search the rows that have been populated, does it timeout/error? ...more >>

Hi, I'm verry new in the world of full text index and I got some problem with my search engine when a hyphen is envolved. For example : I've got "Casse-croûte" in my table under the column name_org. When I search for "Casse-Croûte", it find it. But when I search for "Casse-CROûte" or "cASSE-cr...more >>

Hi, I have an FTS table on which I execute a CONTAINSTABLE(ISABOUT..) . the search works fine but I noticed that after I do an incremental population or after a track changes has been triggered by a change in the data then I get different rank results between identical searches (pre and p...more >>

What are the perf issues if I do this? SELECT * from Table WHERE CONTAINS( fieldA, 'keyworkd') OR LIKE '%keyworkd%' It will always do a TABLE SCAN, right? Thanks, Matias ...more >>

What about this? http://www.cfgigolo.com/unsorted/fts_accent_sensitive.txt I don't need to run SPS and SQL 2K on the same machine so it would be no problem to overwrite MSSearch Is it safe to do it? Thanks Matias ...more >>

I have a newly installed Windows 2003 EE sp1 with Sql Server 2000 sp3 machine. I restored a database to the machine that had several full text catalogs in it. I'm trying to go in and do a rebuild on the catalogs. When I do this.. I get the error: Error 7635: The Microsoft Search service...more >>

Dear All, I am trying to implement FULL TEXT service on my table but for some reason its not working. What i want to achieve is that I should be able search text in my word documents also Here is the Structure of my table: ItemID int (Primary Key) ModuleID int, CreatedByUser nvarchar(...more >>

I am not able to find C# using full text search of SQL 2005 beta 2 also, is there a way to enable some special words for indexing, such as c++, c#, thanks --xin chne ...more >>

I have an app that is automatically storing e-mails from Outlook in an image field in SQL 2000. I have found where certain types of files have built in filter support for searching, but .msg is not included as one of these. Is anyone aware of anyway to do searches on the .msg file type within ...more >>

Hello, I'm storing documents (txt, html, etc) as images in my database, and can run regular 'contains' searches on my data just fine, but when I use formsof(inflectional,word), it will only return results that contain the word exactly, not any inflectional forms of it. Is this some known ...more >>

Hi There I have a single server with Win 2000 Server and SQL 2000 SP3a. I have a database with 1 full-text index, and everything works fine...... BUT!! Suddenly the search stops working. There are no errors in the eventlog and all services are running fine. The only way I can start the...more >>

HI I have been reading a lot of the threads in here and i dont quite get all this yet so i hope that you can help me. I understand that you need to make images of the documents that you want to include in the free-text search in the database, but my question is regarding documents that are ...more >>

Hi I need to allow users to search records for Hotel names and can't rely on them spelling names properly. For example, Park Lane could be mispelled Pak Lane, Park Lne, Pakr Ln etc. Does full-text indexing allow me to return the closest approimations to a given search query with misspell...more >>