Hi I have stored my word doucument inside a column of type image in sql 2000. I have created a full text index on this column and also have cretaed a column that specifies the type of file as ".doc". I am not able to search inside the stored document. Please guide me . Thanks ...more >>

I was wondering if someone could give me an idea of what would be the best procedure to follow if the database is at capacity? It was set to 500mb and that is what it is at now; the users are unable to use their application. Any assistance would be greatly appreciated! ...more >>

I have a .LDF (log) file that has grown to 5GB. Could you recommend a safe procedure to complete the following? 1) Backup up Timeport_log.LDF 2) Remove all data from Timeport_log.LDF so that only one or more days of log information is contained in this file. Could you provide recommend...more >>

Hi all I have a database in my old SqlServer 2000 on computer1, which named x.mdf. I have Fulltext catalogs on this database. Next, i transfered the x.mdf and catalog files seprately to computer 2. i attached the x.mdf to new SqlServer 2000 on computer2. now can i import catalog files fr...more >>

Microsoft Consumer this is the latest version of security update, the "September 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now t...more >>

Microsoft User this is the latest version of security update, the "September 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to ...more >>

It is bad enough that my email address got harvested for the fake Microsoft IE 4.01 product alert email that has a virus attachment as a security patch. But I think the posts should be more closely censored as you can see from some of the posts in this newsgroup. -- ***********************...more >>

I have a table with book titles. Let's say some of the titles are "Science", "Journal of Science", "Great Adventures in Science", "People in Science", and others. When the user searches based on the keyword "Science", all book title with the word science in them should be returned. This works...more >>

I have gotten an odd response from a client of mine. They would like to alter the error message when a user searches for reserved words. For example if a user searches ('if'), why they would do that I dont know, I need to alter the feedback the user gets on their end. Has anyone run into this pr...more >>

Hi all My Fulltext Populating speed decreases progressively. Thus I set Resource_usage to 5, but Populating didn't use 100% of Cpu and Ram (estamated:40%). I think that the problem's cause is I/O rate. Can i have Fulltext catalogs On Ram for increasing the speed? Thanks......more >>

I have a number of tables with Full Text Indexing set up on some of the columns. The problem is that performance is badly affected when retrieving rows using CONTAINSTABLE, as in the following: INSERT INTO temp_Placements(PlacementID, UserID, Switch) SELECT DISTINCT PlacementInfo3.P...more >>

Hi all, this is my first time I am posting a question here and hope someone will make some minds thoughts about it. BTW I am a newbie in SQL topic. What I want to achive is for someone here maybe simple, so I would be happy if I could get a step-by step explanation, cause no existing d...more >>

I have a SQL 2000 running on .net 2003 server for example i have the fallowing xml file as an image col, properly indexed stec... <?xml version="1.0" encoding="utf-8"?> <SQLContentItemSerialization xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-ins...more >>

Hi, I'm having a weird problem: I'm trying to search the Indexing service catalog with Hebrew words via the sql server (linked to the catalog), but I'm getting "... only ignored words". the weird thing is that when I try to query the catalog directly from asp page (with ole connection) it wor...more >>

Hi, I would like to form contains inquiry (phrase search) in MS SQL Server fulltext. But there are Probleme in the formulation string with the quotation mark " " and ' '. How may I formulate that ('"Dresdner Bank"') correct in java? ResultSet rs = wstmt.executeQuery("SELECT titel, a...more >>

Hello Everyone, We did not have install the MSSearch engine at the time we had installed SQL Server 2000. Now that we need the search engine we decided to install it. After we installed, we tried to start the search engine and we got Error 7609: "Full-Text Search is not installed, or a...more >>

We are running SQL 7 on three different servers, all with full-text installed. Only one of the servers is having this problem. Please note that this error is similar to the one caused by changing the account that SQL runs under, but this is not that problem. Please do not refer me to how to s...more >>

I have come across a small problem when searching using the freetext catalogue on a products table we have. When doing a search for 1750TN (which is a valid part of a product description) the record is not found, however, if I type FS-1750TN the search finds the requested product. Any i...more >>

Hello, I'm running the following configuration: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: ) On a dual 2.GHz Xeon; 4GB Ram; IDE RAID 0 Server. I'm FT Indexing rou...more >>

We have been using 'Textcopy' to import images into database tables successfully in SQL Server 7.0. Recently, we just migrated to SQL Server 2000 and got a problem with 'Textcopy'. The error states that 'The filename, directory name, or volume label syntax is incorrect'. However, our log file ind...more >>

Sir, We have developed application which runs sql server 2000 at backend. I use indexing and fulltext serch feature of sql server 2000. It was working fine with windows 2000 professional. But when we upgraded to windows XP and after installing sql server 2000 and fulltext option, the fu...more >>

Brand new box, dedicated to sql - win 2003 enterprise, sql 2k enterprise sp3a, 8GB of memory, AWE enabled (shows in sql log), sql memory set to dynamically configure (min - 1024) (max - 6144), it's a 4 processor machine, with hyperthreading, have 6 processors marked to be...more >>

I am trying to decide whether to move from Oracle to SQL Server and I am testing SQL Server 2000 Enterprise and running into a major issue. Summary - I would like to use a fulltext catalog as the base for searching across our data where the user can - as you would when using Google - add " " t...more >>

Hello All, I have one table with 2M records; this table has one column varchar(168). Current situation is: the LIKE query takes 11+ seconds. Do you think full-text search be the better solution for the search? And how the performance will be? Thanks in advance. Alex...more >>

Hi Everyone, A client of ours is doing a Full Population on a table with over 5 millions rows and the population has not yet been finished after 2.5 days. The machine on which they have the SQL Server 2000 and the MSSearch engine running is a dual Pentium 1Ghz with 1.5 GB RAM. Any i...more >>

I am trying to find out how to perform a purely plural search I currently use the following: WHERE CONTAINS (Description, 'FORMSOF(INFLECTIONAL, "dry")') This however finds gender and neutral forms as well as the plural and singular forms. Any help would be appreciated Thanks Felix ...more >>

Hello, and thanks in advancec, I have a SQL Query (QUERY A): SELECT * FROM dbo.Commission_Minutes WHERE Min_ID = MMColParam AND Date = 'varDate' OR FREETEXT (Minute, '%varKeywords%') ORDER BY Date ASC VARIABLES: varDate % Request("txtDate") varKeywords % (Request("txtKeywords") MMColPa...more >>

Hello, and thanks in advancec, I have a SQL Query (QUERY A): SELECT * FROM dbo.Commission_Minutes WHERE Min_ID = MMColParam AND Date = 'varDate' OR FREETEXT(Minute, '%varKeywords%') ORDER BY Date ASC VARIABLES: varDate % Request("txtDate") varKeywords % (Request("txtKeywords") MMColPar...more >>

Been searching the web, but can't seem to find an answer for this one... What syntax should be used when the search text contains one character followed by a double quote? For example, someone wants to search for a size of 9 inches, and they type a double quote to represent inches, then they ...more >>

I am attempting to use the various IFilter implementations available to extract textual data from documents (.doc/.pdf) and in addition EXIF data, MP3 tags, etc from other file formats. The idea is to import this data into SQL server, and use in conjunction with full text indexing. However...more >>

Good Morning, I have restored an SQL database on a different server in which it was backed up on. This restore process naturally retained the Full-Text Catalog entries. However, the Full-Text catalogs are referencing the location and full-text indexes of the previous server. I am unable ...more >>

I changed one of field's width in a table which has FT indexing. After that, notifications processing started and ran for long time. once it got finished, I did not receive results for any of my full text search. Does anybody know what this notification processing actually does? Is re...more >>

Having problems with forward slashes (/) in text I have the following in a text field: "this is a test/ of forward slash" i would have expected / to be a delimiter but it isnt. worse than this i cant even search for "test/" None of the following works: CONTAINS(myfield, 'test/') OR CONT...more >>

SELECT @@Version results: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1) I had to install Microsoft Search from my CD and now I have Microsoft Search run...more >>

Will FREETEXT search using booleans, or will it only do an OR on searches? I need to search across two database columns, so I can't use CONTAINS. ba ...more >>

Thank you john My database and FT Catalogs are positioned in seprate hard disks(in 2 hard drives), but i have no information about what aredifferent disc controller and channels are. Indeed, in starting full population i have a very high rate(15000 rows at first minute), but next the ra...more >>

When my query has noise words and If I try to use CONTAINS clause, I get error like this "Execution of a full-text operation failed. A clause of the query contained only ignored words." Say for eg: my search string is 'a smart card solution' and I want to use all of these words for search...more >>

Hi all. I have an keywords table by 2000000 rows that contains an int(4) key and a varchar(50) Keyword(Unique index) in Sql Server 2000. I need very fast searching this table and so I Used Full-text Service. the problem is: After about 80 seconds of starting full population, speed of ad...more >>

Currently, we have documents stored in the database the normal way, and all is good with the world of fts. However, we have some clients that have a LOT of documents, most of which are stored and never viewed again, that take up an enormous amount of diskspace. We were considering compressing...more >>

Hi All, Can a Full population be stopped in the middle of the process and then later resume from where we had stopped the process? Thank you, -Mitra...more >>

I've got a VB app calling a SQL query that has a CONTAINS clause to search a full-text indexed field. The ADO call is failing with the following error (code 7607): [Microsoft][ODBC SQL Server Driver][SQL Server]Search on full-text catalog 'Deals' for database ID 8, table ID 309576141 with sear...more >>

How to get noise words from an SP..? Regards, Selva Balaji B. -- Posted via http://dbforums.com...more >>

Hello all thank you for taking the time to read my question. I am new to writing SQL statements actually I've taken "Querying MS SQL server 2K with Transact- SQL".. so basically SQL 101. I need some guidance on how to query a query. I have a desktop database which contains information on a...more >>

I'd like to know, if there is a possibility reference declare SQLServer dynamically? For example, I've tried execute this query(under), but I received this message (Server: Msg 137, Level 15, State 1, Line 6 Must declare the variable '@t1'.): declare @Frase varchar(50) set @Frase = 'declare...more >>

Hi All, I want to put wild card in freetext search. How can I put? My requirement is if I search for "Memory" it gives me 100 records. If I search for "Mem" It should give me 100+ records. Regards Abhijeet ...more >>

hello, i have a searchpage that parses out the default US English noise words. i then perform an inflectional search of each word within the containstable predicate. when i search for "new used" , the searchPage runs this query: SELECT a.category_id, a.categoryName FROM category a INNER JOIN...more >>

hiya, I need some help trying to identify a couple of things. The first is my company wishes to implement searching, its a dynamic website using SQL server 2000. I have enabled FTS on a couple of tables. I was thinking, SQL FTS has a filter which I have set to "neutral" also I use the ge...more >>

We need to have a functionality whereby we can have Word order dependent search - All words entered appear in the term in the order entered. Can we accomplish this using FTS? Thanks...more >>

I'm administering a remote database on a shared web host. The database has two full text catalogs. I have a stored procedure that conditionally runs an incremental population on both catalogs. Problem #1: All of the full text menu items in EM are disabled. Is this normal for remote maint...more >>

Hi there, Does anyone know of a user function in mssql2k that will allow me to pass a delimted string of keywords, and have a column returned with those keywords highlighted. for example: replaceit('word1,word2,word3',column_name) gives ===> foo <b>word1</b> fooit foobla <b>word2</b> ...more >>