Hilary, John, SOS! I had a major crisis with my sql server today. After applying Hilary's great advice from here: http://tinyurl.com/inyn I was able to get things in order. I'm getting this new error now. It disappers after I try to re-build, but as soon as I populate (full/incremenet) - I ...more >>

Is there any way, shape or form that the following stored procdure can be called successfully? Basically I am trying to passing in a WHERE clause that contains some full-text predicates (CONTAINS, etc...). This WHERE clause has to be a variable passed in. The 'public' role has NO rights to th...more >>

I'm trying to write a search query for a forum. I've started with this: SELECT Posts.TopicID, ft.[RANK] FROM Posts INNER JOIN FREETEXTTABLE (Posts, *, @SeachTerm, 100) AS ft ON Posts.PostID = ft.[KEY] ORDER BY ft.[RANK] DESC No problem there, and it's fast and the results are really accura...more >>

Hello, One of our people started to make a full text index on a table. The table has over 8 million records and would take about 3 days to complete. Our boss wants to stop the population process of the index but it does not appear to be stopping. They have issued the command from the SQL...more >>

Why when searching for more than one word in a text search and at least one word (but not all) is a noise word i get the msg - "The query contained only ignored words" . for example : if the search text is "what does Allergist do?" i get the msg despite the fact "Allergist" is not noise word. this...more >>

I ran into this white paper on FTS with SQL 2000, http://support.microsoft.com/default.aspx?scid=kb;en- us;323739 in which it states that if you install the SQL 2000 on Windows 2000, the FTS service is not available. I also read some threads talking about the availablity problem of FTS ...more >>

Ok, yet another strange FTS problem. We're still running SQL 7.0 SP2 (can't upgrade yet) under Windows 2000. We've had more than our share of FTS issues. So the latest is, on our primary, I build a brand new catalog of our main table. No problems. 4-5 days later, it finishes. So the...more >>

I have an active passive cluster in a production environment. I also have a non-clustered sql server for testing. I made a change to the noise.enu file to remove some noise words, I did this on test and everything worked fine. I then went to production and did the exact same thing, stopped full-...more >>

Hello Everyone, I read on SQL Server Books Online that the Incremental population for Full-Text Indexing: "requires that the indexed table have a column of the timestamp data type. If the table does not have a timestamp column, only full or change tracking populations can be performed....more >>

I have these two tables can link with out problem, it does not work on SQL. 'Store List' table saved successfully 'EQUIPS' table - Unable to create relationship 'FK_EQUIPS_Store List'. ADO error: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_EQUIPS_Store List'....more >>

I am attempting to execute a .bat file that contains the following: ftp -s:c\ftpinput.txt >> c:\ftpoutput ftpinput.txt is a file that contains ftp commands I then receive an error message: The process cannot access the file because it is being used by another process. The file (ftpinput...more >>

Hi everyone, I have a Oracle database application which has an index on varchar2(2000). Now I am moving the database to Sql Server and facing index limitation problem. Sql Server only allow you to build index on column which has less than 900 bytes. Is there anyway in Sql Server to build ...more >>

Hi, I've the FTS in a stored procedure and i am calling the stored procedure from ASP program. Here is the stored procedure : -- ============================================= -- Create procedure basic template -- ============================================= -- creating the store proced...more >>

Hi there, I want to search Japanese characters with Full Text search function. I created a new database on SQL 2000, English Win2k Server. The database's collation is "Japanese-bin" and contains one table that contains 4 fields, which are ID -- int, primary key, identity; PageName -- nvarchar...more >>

"We have a few SQL files on the server that seem to be growing in size and don't know what they are for. The files have similar names of the type: SQL0000700005.hash.gthr" Can someone let me know why and what are these .hash.gthr files are meant for. In my wisdom they are related someways...more >>

Gents, We just made transition to SP3 on our production server. After a lot of hassle rebuilding the FT indexes, we now running a few days with this set-up. However, what we notice is that the FT query performance seems to have slowed down. A process that took 10-12 minutes before, now take...more >>

I am trying to query a table that is on both my test and production machine. It works fine on test. It does not work on production (a cluster). I don't see any error messages in sql or the event viewer. When I run a query on test it returns a result set. Production does not. I see this in th...more >>

I am trying to create a query which will remotely rebuild an SQL Full-Text catalog that has been stopped and is otherwise inaccessible without visiting the server site and rebuilding in Enterprise Manager. Anyone who can offer me some advice, your help would be greatly appreciated. Regards, ...more >>

I start the full text search service from the SQL Server Service Manager, but in the enterprise manager, all actions concerns with the full text search are all unable to choose, what is the problem? ...more >>

Hi folks! I'm enabling FT indexing on 2 tables. On one table it work good because it has a single column primary key and index. The other table is problematic one. It has a primary key consisting of three fields and index. We used incremental method for FT so we have timestamp column in this ta...more >>

Hi, does anyone know how the quality of the FTS in Typo3 (PHP/MySQL) compares to SQL's? - I have to do a competitive bid and have few infos on Typo3, but I already know a lot about SQL's FTS. I also know that Typo3 seems to be limited to html, txt and doc. PDF seems possible if you use an exte...more >>

Hi, I have a database that I want to search for words that have special characters inside like a dash or a slash like "T-SQL" or "T/SQL" with the CONTAINS clause. I tried CONTAINS(description,'"T-SQL"') and it gives me the count of rows with "SQL" appearing in the description field whi...more >>

We're implementing FTS on SQL 2K from scratch. I've never done this before - so please excuse (and highlght) newbie-type mistakes. Looking for advice on best way to design for the following: Goals: Query Speed Ease of Maintenance Less Important (I think): Population time Situation: ...more >>

Hi, I'm using FTS on a SQL Server 2000 database populated with spanish text, so I need to enable the spanish options for noise words and word breaking. All the documentation says that SQL Server includes the following linguistic analysis packages: Chinese_Simplified Chinese_Traditio...more >>

Hi, Windows 2000/ SQLserver 2000 sp3 i want to put fulltext search for my reports. so i tried the fulltext search testing on my test server. the Mssearch is taking 90% Cpu. So i dont want to put the search service in my production box. I want to move the data to report server using Tra...more >>

I'm writing a proc that has an input parameter called @keyword. The proc will then use this paramter in a where clause as follows: WHERE CONTAINS(item_long_description, @keyword) The problem I am having is when the @keyword parameter is null, the proc needs to return all records in the ...more >>

Is there any way to throttle disk usage or I/O for mssearch? I have a 10,000 rpm drive on a 160mb/sec connection and mssearch just hammers it to death at 100% on my performance monitor. -Craig ...more >>

Has anyone played with or heard of the [STARTPHRASE] [ENDPHRASE] tags? ...more >>

I have a database file : drive D: ldf file drive E: Catalog files for database drive F: mdb file Problem - Drive D: is going bad, corrupt but everything still works ok. (ldf is not corrupt) I need to move the LDF to F: drive but I dont want to rebuild the catalogs as they would take 1 wee...more >>

Is it possible to find out the list of common words reserved by MS Search? In sql server fulltext search, if I want to find something with common words, like "The King", but in exact match, what can I do? I tried many ways but failed. Thanks. Cheers, George ...more >>

I'm currently using MSSQL 7. AND have successfully Indexed a database table. Made sure that services for MSSearch and SQL Agent are running. When I try to run my query it returns 0 rows. But it actually should give me 1 row as a result. SELECT * FROM RESUMES WHERE CONTAINS(ResumeText,'html...more >>

Hello everyone! I'm trying to build a large fulltext catalog, which takes almost a week. (in a ULTRA SCSI-2 RAID 100GB,512 RAM P3,SQL2K,WIN2KAS SP3). I want to monitor the actual status (ItemCount,StartDate) of the population via either DMO or a SQL Statement, but I haven't found it ...more >>

Hello, I have installed the XML ifilter from msdn. SQL2000 sp3 on WK2 1 do I need to rebuild my FTS catalog? It looks like it does not index my 'old' XML files. Since it is about 500 mb big, this would mean 1 day of rebuilding. 2 does anyone know what this filter indexes (readme is too short)...more >>

Platform: Win2K SP3 SQL: Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3) CREATE TABLE [dbo].[CustomField_10009] ( [Record_ID] INT ...more >>

I was wondering if there is any way to include some sort of fuzzy logic when performing a full text search. Something like the SQL Server implementation of SOUNDEX so if the user searches for say "John" in a full text column, the search should also return Jon, Jean etc. I came up with a stored pr...more >>

Hi, I have found following code in Commerce server catalog module. Can and one explain why to use 'ContainsTable' if the search phrase contains AND IF (Charindex(N' and ', @FTSPhrase) = 0 ) BEGIN SET @FTSFunction = N'FreeTextTable' END ELSE BEGIN SET @FTSFunction = N'ContainsTa...more >>

I tried to use full text search on image columns. I set it up by following the instruction on the online book. however, it does not work. The query always returns nothing once a image column is included in the full-text indexing. I have no problem of using full text search on any other typ...more >>

Hi all. I am new to the full-text search functionality in SQL and cannot determine why we are experiencing the following anomolies: We have three servers, all running Windows 2000 and SQL Server 2000. Servers 1 and 3 have SP3, Server 2 has SP2. When we run a full-text search for "Abbot...more >>

i found that sql-server full text search is only capable of searching the newly inserted items after an incremental or full population. Is there any possibility to search the newly inserted without re-populating the full text search database? thx ...more >>

Hello, We are discussing the requirements of a database application with one of them being the ability for users to serch a text field that contains a description of a play in a hockey/basketball game. For example: Wayne Gretzky power play goal was his 50th of the year My impression is th...more >>

I am trying to install the sp5a service pack on SQL 6.5. I am getting an error message of "setup initilisation could not be successfully completed. ISQL.exe could not be executed. Please check the relevant .OUT file." I first received this type of error on the cfgchar.exe file, but i got r...more >>

Hi, ranking is determined by a formula that accounts for the frequency of the word in the document/row compared with the frequency of the word occuring in all documents/rows weighted against the total number of unique non-noise words in your catalog. Does this means that if I have fulltext ...more >>

Hi All, I have one table Customers in Northwind database. While performing FreeText search I want to give weightage ON Columns for a searched phrase. CompanyName weight (1) ContactName weight (.7) ContactTitle weight (.5) ...more >>

> I am having a problem when querying data from database. > Some of the queries throw an exception and I don't know how to fix it. > > The error I get is "Query Contains Only Ignored Words" (#7619) > > Any help would be appreciated -- Dino Buljubasic Software Developer http://rivusglob...more >>

Microsoft Search is running as LocalSystem and MSSQLSERVER as .\Administrator But I can not run sp_fulltext_database 'enable' I still get the error message (1 row(s) affected) Server: Msg 7635, Level 16, State 1, Procedure sp_fulltext_database, Line 46 The Microsoft Search service canno...more >>

I have a database that has one column that I've given full- text indexing so that I can do searches and what not. The only problem is that every time data is added to the index, it doesn't automatically become fully indexed and consequently can't be fixed. I know i'm doing something wro...more >>