Hi 1) I am using SQL Server 2000 Select @@version => Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4) 2) I just installed SP3a for SQL Server 3) I am u...more >>

Hi Hilary (or anyone else), I'm looking for the good ol' searchpage1.htm page - Google does not seem to have it cached. Can you provide a copy of the code please? Many thanks, Alan ...more >>

I have SQLServer 2000 (Developer edition) and have installed SP3a in an attempt to get full word in text searching. (both installed as administrator on a Windows XP professional box) However, I dont get MSSEARCH in the list of services and hence the 'Full Text' Indexing option is grayed out. ...more >>

Hi, After remove a large table (2Gb) and shrink database, I found this error: "Error 7608: An unknown full-text failure (8007007e) occurred in function CreateCatalog on full-text catalog 'mycatalog'." Function can be "CreateCatalog" or "EnumCatalogs" according a command that I use on Ful...more >>

Hi all, I have a nvarchar(255) column on a tblKeyword table with many queries in a verified FTS form. i.e- "Microsoft Corporation" ("Hewelet Packard") OR HP Google OR Froogle Sun I want to issue a combined FTS query that will gather all (*) information from the indexed table, based on ...more >>

Hi, I'm planning to store some romanian documents in SQL image. I understand that I have to use neutral language. What I need to know if FTS is accent sensitive: some peoples writes "acasã"(means home), others simply "acasa". The query "acasa" returns "acasa" and "acasã" or only "acasa". S...more >>

Hi guys, I'm using FTS on sql server 2000 I would like to write a stored proc that accepts conditional CONTAINS. This means that if @param1 was provided I want to apply CONTAINS with certain column if not apply it to the other column WHERE CASE WHEN @param2 IS NULL THEN ...more >>

Can someone give me an estimate time to populate a full text index, SQL Server 2000 -14 million rows - each row is about 1 paragraph long. (approx 400 words and is stored in a LONG TEXT field - Language of the text: mixed - W.H.:a single CPU 2.8GHZ with 2GB Ram and have 300GB disk spac -increm...more >>

Hi there, I have taken over a SQL 2000 database and within it is a table which has content for ASP web pages. Some of the content is pretty long, and for some reason is displayed as <Long Text> in the table, up returning all rows. I need to change this text, how can i do this by ammending t...more >>

here's my scenario. i run enterprise manager from the pc to manage my db servers. i've configured and tested fulltext on a development server. i began to configure it on a test server that is on the other side of one of our firewalls but can't. no fulltext options are available anywhere (the...more >>

i've been a sql server dba for the last six years, but we're just now going to implement full text searches so i've got some dumb questions. 1) is the only way to make the fulltext searches realtime, ie document is indexed immediately after being added to the db, is to enable change tracking a...more >>

Can someone help me or provide a workaround? The object is to select all articles which are not references to other articles. The problem I am having is when I try to get the ReferenceCount (which is the count of articles which reference this article) it is throwing a 42000 (Error 170: Line 6:...more >>

How can I determine if I need to use the SQL Server Fulltext services? This error messages occurs when the CPU is greater than 80% for extended period of time. Usually the error message occurs when the system has a major deadlock and is using all the resources to resolve the deadlock....more >>

Hi, Is it possible to backup and restore full text indexing? If Yes, how to do it? Can we restore that backup when full text index is 'recovering'? Help would be appreciated. Thanks in advance. Rajah V....more >>

I have got a keyword search working on my site. When new items are added to the database they don't show up. How do I trigger an incremental repopulation everytime a new item is added to my table. I was under the mistaken impression that this was what incremental population did. ...more >>

hi, we are using successfully the fulltext search feature of mssql2000, filtering possible noise words based on the noiseword-file for the locale of interest (in our case germand [noise.deu]) in the \MSSQL\DATA\MSSQL\FTDATA\SQLServer\Config directory. now we discovered a strange behaviour: th...more >>

Hi everyone, I am developing a web app and wanting to store documents (doc, xls, pdf, ppt...etc.) within the DB (MSSQL). Is it advisable in general (I don't know exactly how big the docs are going to be) to compress the files before putting them into the DB? How does this affect Full Text Sea...more >>

Hi there, I have a quite large products table, with the following fields: Product_title nvarchar(100) Product_summary nvarchar(1000) Product_description text Is it possible to run a FTS query throughtout all of this 3 fields? For example, user searches for:...more >>

Hi, I have SQL Server 2000 Personal edition installed on XP Pro and am trying to implement the full-text search facility. There doesn't seem to be any option to install fts on my SQL Server CD so I assumed it should be installed by default. However, when I try EXEC sp_fulltext_database @a...more >>

Hi We have a problem with the italian version of full text searching. We are using an inflectional search to account for plurals and verb derivations. The search is on a product list containing grocery items. The italian word for bread is "pane". Our search is bringing back, amongst entri...more >>

Hi Desperation has lead me to post. Usually I am able to fix problems by just reading through the newsgroups. I am working on a full text search for an image column. I have an image column (docData) defined - as image (16) and a docExt column defined as char(4). Here are the results of sp_hel...more >>

Any idea what is the set up process is? I've tried a couple of different character set and it's still not displaying the characters correctly. I could insert the Chinese characters into a table using INSERT with no error, but the SELECT statement shows "???" Thanks for any help in advance....more >>

Is it necessary to upgrade SQL Server version 7 to 2000? Real question is that 'What's new in version 2000 from version 7?'...more >>

I have a four join database - category as the one and the Subcategory as the many and so on Category SubCategory Announcement SubAnnouncement I have full text indexes on descriptive columns in the Announcement and Sub Announcement. I would like to use a containstable or freetexttable to r...more >>

Running on SBS 2003 Server Premium: I've looked at everything I can find here and elsewhere, and still can't figure out what is wrong. Will also post this on WSS newsgroup. \SHAREPOINT instance was upgraded from WMSDE to SQL Server 2000 instance, and Search is selected in WSS. local ...more >>

Hi, I am using FTS on SQL 2000 SP3, Windows 2000 Server SP4 (German). I do not get any results when words are surrounded by special chars. Example: CONTAINS(PlainText, 'koppmann') does not find: * file:///D:\Koppmann\Downloads * martin.koppmann@myserver.com Is it possible to find such oc...more >>

Hello, Is there a query or a method that can return the list of all the indexed words in a column that has been full-text indexed in sql server 2000? I need to get the words returned above in a Containstable[] query on another column to get a rank that can suggest a degree of similarity betwee...more >>

I am using containstable for searching name and address etc. WHen I am searching with charecters i am getting back records. But for address the query is not returing any records. Can any body give any resourece site or any examples so that I can work with them? Please....more >>

I'm seeing vastly different search results from a NT box and a W2K box when one of the search words is in the noise file. The noise files are identical. The NT box finds all the records while the W2K server misses most. Here is a portion of typical sql string: WHERE c.creatorId=m.creatorid AND ...more >>

I have upgraded from SQL7 to 2000 SP3 on a Windows 2000 Server machine. Full-text indexing is greyed out. I have ran net start mssearch and it is already running. Any suggestions would be helpful...more >>

Hi, I have a hard time to get the fulltext index to recognize the the exact word .NET (not case sensitive) My query: select * from TestTable where contains(Content,'".NET"') The fulltext index returns all occurences like NET NET+ .NET I am running: Microsoft SQL Server 2000...more >>

Hi, I am developing Knowledge Database(intranet) for my compnay. I am using SQL Server 2000 as DB and Active Server Pages as Scripting language. I have a table, tb_kdb with 3 fields(title,keyword,description) as text type. I am insering the form data into DB after encoding.for e.g r...more >>

Hello, When I run an incremental/full job for a full text catalog on win 2k , SQL 2K sp3a cluster server, i am getting this in the SQL error log Login failed for user domain\servername$ We recently removed the local admin group having syadmin access to the server. I changed the J...more >>