Full Text Search slow, then fast for 30 minutes, then slow again

We've just upgraded a database to SQL 2005 Standard sp1 on a Windows 2003 sp1 server and we are experiencing a problem with Full Text Search. We recreated a Full Text Catalogue in the new SQL 2005 db and it seemed to populate fine. However, now when we run a query on that FTI for the first time it takes about 30-45 seconds to return a result. After that first query, subsequent queries return the result immediately. Then if there is an approximate 30 minute gap until the next query is run then it goes back to taking 30-45 seconds to return the result. It seems as though the results of the query are cached and remain in the chache as long as queries continue to be submitted at <30 minute intervals. If a query is not submitted in 30 minutes then the cache expires. That is only my theory. Has anyone seen this issue? Any insite you can provide is greatly appreciated. Thanks.Does your system have internet access? On loading the system resources for FTS, it will connect to the internet to validate the signature. The duration is about what you've reported, 45sec. After about 30 minutes of no activity, the resouces will be unloaded to save memory.

So, to keep the resources in memory you could create a job that execute the query every 10minutes.|||

Hi OJ,

The signature of what? Is there any option to disable this validation?

Please advice. Thanks, Radu.

|||It's the signature of the DLLs/binaries used by MsSearch (FTS) service. You can turn off the checking by running

exec sp_fulltext_Service 'verify_signature',0

Full Text Search slow, then fast for 30 minutes, then slow again

We've just upgraded a database to SQL 2005 Standard sp1 on a Windows 2003 sp1 server and we are experiencing a problem with Full Text Search. We recreated a Full Text Catalogue in the new SQL 2005 db and it seemed to populate fine. However, now when we run a query on that FTI for the first time it takes about 30-45 seconds to return a result. After that first query, subsequent queries return the result immediately. Then if there is an approximate 30 minute gap until the next query is run then it goes back to taking 30-45 seconds to return the result. It seems as though the results of the query are cached and remain in the chache as long as queries continue to be submitted at <30 minute intervals. If a query is not submitted in 30 minutes then the cache expires. That is only my theory. Has anyone seen this issue? Any insite you can provide is greatly appreciated. Thanks.Does your system have internet access? On loading the system resources for FTS, it will connect to the internet to validate the signature. The duration is about what you've reported, 45sec. After about 30 minutes of no activity, the resouces will be unloaded to save memory.

So, to keep the resources in memory you could create a job that execute the query every 10minutes.|||

Hi OJ,

The signature of what? Is there any option to disable this validation?

Please advice. Thanks, Radu.

|||It's the signature of the DLLs/binaries used by MsSearch (FTS) service. You can turn off the checking by running

exec sp_fulltext_Service 'verify_signature',0

full text search on doc files

I have a list of word files (.doc) I am trying to us the full text
search in sql server to find key words in these word documents. I have
a Windows XP and sql server installed on my machine. ( no network
server). I cant seem to get the code to work to do a search on these
files. I would really appreciate if someone can send me some code from
start to finsh so I can create the sql tables and then catolog to
search for keywords in the word files.What version of SQL Server are you using? Word documents must be stored in
columns of data type image, and another column must be present to store the
type suffix (".doc" for MS Word files).
When full-text indexing is activated for an image column the name of the
column where the suffix is stored must also be set. How this is actually don
e
depends on the SQL Server version.
SQL 2000:
sp_fulltext_column
@.tabname = '<qualified_table_name>'
,@.colname = '<column_name>'
,@.action = 'add'
,@.type_colname = '<type_column_name>'
SQL 2005:
create fulltext index on <table_name>
(<column_name> TYPE COLUMN <type_column_name>
key index <index_name>
If the index has been created appropriately, then you might also check the
SQL Error Log:
http://milambda.blogspot.com/2005/1...n-or-bybug.html
ML
http://milambda.blogspot.com/|||ML,
How do i create the table first and get the files indexed? How do I
get the files catologued? i am using sql2000 . Do i run the sql you
wrote above after the files have been imported?|||Setting up full-text indexing in SQL 2000 is very well documented in Books
Online:
http://msdn.microsoft.com/library/d... />
d_6g1f.asp
After you've created the table and enabled the database for full-text
search, you need to enable the table, then the column for full-text indexing
.
It really doesn't matter whether you set up FTI before inserting data in the
tables, or after, as long as you propagate change to the catalogue before yo
u
try to use full-text search (new rows will not be found by the engine until
the contents have been indexed).
There are several methods of propagating change to the full-text catalogue:
full propagation, incremental propagation and background propagation (with
change tracking). With background propagation new rows are indexed after
they've been inserted and changed rows are indexed after they've been
updated, but there's a performance impact and writetext/updatetext operation
s
are not detected.
To avoid the downside you could use incremental propagation by creating a
SQL Agent Job that starts incremental propagation as frequently as you need.
Are you having any specific problems? You could also ask these questions in
the dedicated newsgorup: "microsoft.public.sqlserver.fulltext".
ML
http://milambda.blogspot.com/|||ML,
I have looked through the link, still not getting it to work. I guess
i need some code, from start to finish, loading the file from the
c:\... and then running the sql. Anything you may have would be
extremely helpful..thanks|||The link I sent you will help you set up full-text indexing, but the actual
method of inserting MS Word documents into the table depends on your client
application.
If you need to insert blobs through T-SQL, you could use BULK INSERT:
http://msdn.microsoft.com/library/d...br />
4fec.asp
Also make sure you create the format file in accordance to this KB article:
http://support.microsoft.com/defaul...kb;en-us;271344
Information on using format files:
http://msdn.microsoft.com/library/d...>
bcp_9yat.asp
ML
http://milambda.blogspot.com/

Full Text Search for Stand Alone Windows App

I am working on a stand-alone windows application in which I need to provide full text search capability. I was using SQL Express edition and was planning to deploy the database (.mdf) with the application.

Is it possible to enable Full Text search for a database which does not belong to a database server (embedded with the app)? If yes the how can you do it?

If its not possible then what are the alternatives/options of data-storage for a windows app which will allow me to enable Full Text search?

Thanks for your help.

To enable full text search your sever must be installed with this capability.

To enable this capability in the sql server 2005 express edition, you have to download the sql server 2005 express edition advanced. This will install the database server, the sql managment studio and the full text serch.

|||

Thanks for your reply. However I already have the "advanced services" installed but my full text button is still disabled in VS Server Explorer.

If I add the database on a named instance for instance MyBox\SQLExpress then i get an option of enabling the Full Text Search but I dont see any option for a stand-alone database file.

|||

Hi,

I would like to introduce some good video learning resources to you which demonstrates how to set up Full-Text within SQL Server Express.These resources demonstrate how to set up Full-Text search paying particular attention to the nuances of setting it up within SQL Server Express.

http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#13

Hope that helps. Thanks.

|||

Thanks a lot for your reply. I found out that full text is not available for "user instances" that is why I am not able to get it to work.

I think I may just have to go with SQL Lite. Does any one know any other database solution which might be better then this? Thanks.

Full Text Search component Problem

Hai
i having Mssql Server 2000. My System OS is Windows xp and Ram 1 Gb

I having Install MS Sql Sever Service Pack 3 in my system. then i
install Full Text Search component

I run this Command

SELECT @.@.VERSION

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack
2)
SELECT SERVERPROPERTY('productversion') return =8.00.760

SELECT SERVERPROPERTY('productlevel')= Return SP3

SELECT SERVERPROPERTY('IsFullTextInstalled') returns: 0
but i run This command i got This Error

EXEC sp_fulltext_database 'enable' returns:

Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database,
Line 46
Full-Text Search is not installed, or a full-text component cannot
be loaded.

i check the Microsoft Search service in Computer Management,
Microsoft Search servic runing Properly
pls advice me

Try this :

http://support.microsoft.com/default.aspx?scid=kb;EN-US;827449 This is the page to reinstall Microsoft Search (Full-Text) Service.

Good luck.

Full Text Search component Problem

Hai
i having Mssql Server 2000. My System OS is Windows xp and Ram 1 Gb

I having Install MS Sql Sever Service Pack 3 in my system. then i
install Full Text Search component

I run this Command

SELECT @.@.VERSION

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack
2)
SELECT SERVERPROPERTY('productversion') return =8.00.760

SELECT SERVERPROPERTY('productlevel')= Return SP3

SELECT SERVERPROPERTY('IsFullTextInstalled') returns: 0
but i run This command i got This Error

EXEC sp_fulltext_database 'enable' returns:

Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database,
Line 46
Full-Text Search is not installed, or a full-text component cannot
be loaded.

i check the Microsoft Search service in Computer Management,
Microsoft Search servic runing Properly
pls advice me

Try this :

http://support.microsoft.com/default.aspx?scid=kb;EN-US;827449 This is the page to reinstall Microsoft Search (Full-Text) Service.

Good luck.

Full Text Search - Conatins doesnot work

Our SQL Server 2000 (sp1) on a Windows 2000 system is configured for a full text search.

The ntext column having a full text index has a value as follows:

Rob Proctor's Tips: Creating a "Tropical" Get-Away At Home

when I search it by

SELECT NTEXT_COL
FROM FULL_TEXT_TABLE
WHERE CONTAINS(NTEXT_COL, N'"Tropical Get Away"')

it displays the result as

NTEXT_COL
======================================
Rob Proctor's Tips: Creating a "Tropical" Get-Away At Home

But the query

SELECT NTEXT_COL
FROM FULL_TEXT_TABLE
WHERE CONTAINS(NTEXT_COL, N'"Tropical Get Aw*"')

do not return any rows..

Can anybody give me the reason for this behaviour, or is it a known bug?

Thanks

Sajan'Get' is included in Noise-word file and therefore query does not return what do you expect. Just remove hyphen from Get-Away (GetAway), repopulate index, run query and you'll see.

SELECT NTEXT_COL
FROM FULL_TEXT_TABLE
WHERE CONTAINS(NTEXT_COL, N'"Tropical GetAw*"')

I agree it is stupid but I guess it was designed this way. You could update list of your Noise words but size of indexes will be increased...

Full text search

I am asking about installing Microsoft Search service in SQL Server 2000 in Windows XP Professional

Is that possible?

And By the way it's not possible for me to switch to SQL Server 2005 that I know that full text indexing already exists in it

thanks

To run SQL Server 2000 Full Text in WinXP you must have the Developer edition if not I don't think you can install it except the Eval which with the release of SQL Server 2005 no longer exist. I have not used the SQL Server 2005 version but the person who runs the blog below can answer all your questions. Hope this helps.

http://spaces.msn.com/jtkane/

sql

Full text search

Hi everyone

I am using SQL server 2000 with SP3 on Windows 2003 server.

I have scheduled a job to populate a full text index incrementally. Everytime it runs the job to populate the index table it writes some messages into event log.
Like this:
1.
Event Type : Information
Event Source : Microsoft Search
Event Category: Gatherer
Event ID : 3019
Date :8/7/2004
Time :2:21:00 PM
User : N/A
Computer : ARC-03-DEV
Description:1
The crawl on project <SQL Server SQL00002000009> has started.

2.
Event Type : Information
Event Source : Microsoft Search
Event Category: Gatherer
Event ID : 3047
Date :8/7/2004
Time :2:21:00 PM
User : N/A
Computer : ARC-03-DEV
Description:
The end of the incremental crawl for project <SQL Server SQL00002000009> has been detected. The Gatherer successfully processed 998 documents totaling 0K. It failed to filter 0 documents. 998 documents were modified. 0 URLs could not be reached or were denied access.

The event log is getting filled frequently.

Is there any way to stop this messages?
It is normal for Microsoft Search to write this message into EventLog?
Even though there is no chanage in the database it give the above messages.

Any one know the reason please help.

Quick reply is appreaciated.

Reagrda,

Atiq RahmanYes, there is a way to suppress the message, but it is a bad idea so I don't remember the details.

Yes, it is perfectly normal for the indexing service to issue those messages, even if it doesn't make any changes.

-PatP|||Hi Pat,

Thanks for the information.

I want to stop this entries getting into Eventlog. Even if it is bad, if you remember please let me know. I want to try it.

Regards,

Atiq Rahman

Full Text Search

Hi,
We have a windows 2003 server (standalone) running SQL server 2000. We need to enable full text search on the database available in it. We have already added full text search in the installation and the option is available but when we try to create a full text catalog on any of the databases, it crashes ie., doesnot respond and gives the typical 'report to microsoft window'. We need to restart the SQL server after the same. can someone help us out.
Thanks
SmithAnything show up in the SQL Server errorlog? Also, did you apply all the service packs so the full Text Search executables are at the same version as the rest of your SQL Server?|||thanks for the reply
no nothing is shown in the event viewer. yes the service packs are the same..
smith|||How about SQL Server's errorlog?|||no help in errorlog too..|||Hi
We had rebuild the SQL server and now we are able to do FTS on just a single database. When we try to create Full Text catalog on other databases the MSSearch service stops. When we restart it, mssql is stopped. Is it not possible to have FTS in more than one database??

Thanks
Smith|||In SQL Server 2005 you can have multiple catalog for one database but each catalog can not contain more than one database.sql

Full Text Indexing on Microsoft SQL Server 2000 with Windows XP Pro

I am wondering if FUll Text Indexing is suported with MS SQL Server 2000
Developer Edition on XP Pro SP2 . I have the service installed and setup. I
have created several catalogs with data but when they are done populating
they show up with an Item Count of 0 and a Unique Index of 1 despite the
fact that there are 10+ records with extremely different data in the 3
columns that are being indexed.
I am not seeing any unusual messages in the Event Viewer also. I have
uninstalled and reinstalled already and the Server is running under an
Administrator User
Hi,
Thanks for your post.
From your descriptions, I understood that you would like to know whether
Full-Text Search is support in SQL Server Dev Edition and how to implement
it. Have I understood you? Correct me if I was wrong.
Based on my scope, Full-Text Search is supported in SQL Server 2000 Dev
Edition on Windows XP Pro. See more deatiled descritption about this in the
following links
Features Supported by the Editions of SQL Server 2000
http://msdn.microsoft.com/library/de...us/architec/8_
ar_ts_1cdv.asp
For the second question, I am not sure your detailed steps on how to
implement the Full-Text Search for the Table, would you please give me more
detail information about doing so? Here is an sample doing this with SQL
Server Enterprise Manager.
1. enable a table for full-text indexing
- Expand Databases, expand the database in which the table belongs, and
then click Tables.
- In the details pane, right-click the table, click Full-Text Index Table,
and then click Define Full-Text Indexing on a Table.
2. To create a full-text catalog
- right-click the database where you want the full-text catalog.
- Click New, and then click New Full-Text Catalog.
- Complete the New Full-Text Catalog dialog box.
3. Make a Full Populating
- expand the database that contains the full-text catalog to rebuild.
- Click Full-Text Catalogs, and then right-click the specific catalog to
populate.
- Click Start Full Population
4. See whether the data had been updated
- right-click the specific catalog to review.
- Click Properties, and then click the Status, Tables, and Schedules tabs,
as appropriate.
See the following chapter in Books Online or MSDN Online for more detailed
information
Creating and Maintaining Databases -> Full-Text Indexes ->
Administering Full-Text Features Using SQL Enterprise Manager
Hope this helps and please feel free to let me know whether it works or you
need furhter help. Thank you for your patience and corporation.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Full Text Indexing on Microsoft SQL Server 2000 with Windows XP Pro

I am wondering if FUll Text Indexing is suported with MS SQL Server 2000
Developer Edition on XP Pro SP2 . I have the service installed and setup. I
have created several catalogs with data but when they are done populating
they show up with an Item Count of 0 and a Unique Index of 1 despite the
fact that there are 10+ records with extremely different data in the 3
columns that are being indexed.
I am not seeing any unusual messages in the Event Viewer also. I have
uninstalled and reinstalled already and the Server is running under an
Administrator UserHi,
Thanks for your post.
From your descriptions, I understood that you would like to know whether
Full-Text Search is support in SQL Server Dev Edition and how to implement
it. Have I understood you? Correct me if I was wrong.
Based on my scope, Full-Text Search is supported in SQL Server 2000 Dev
Edition on Windows XP Pro. See more deatiled descritption about this in the
following links
Features Supported by the Editions of SQL Server 2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_ts_1cdv.asp
For the second question, I am not sure your detailed steps on how to
implement the Full-Text Search for the Table, would you please give me more
detail information about doing so? Here is an sample doing this with SQL
Server Enterprise Manager.
1. enable a table for full-text indexing
- Expand Databases, expand the database in which the table belongs, and
then click Tables.
- In the details pane, right-click the table, click Full-Text Index Table,
and then click Define Full-Text Indexing on a Table.
2. To create a full-text catalog
- right-click the database where you want the full-text catalog.
- Click New, and then click New Full-Text Catalog.
- Complete the New Full-Text Catalog dialog box.
3. Make a Full Populating
- expand the database that contains the full-text catalog to rebuild.
- Click Full-Text Catalogs, and then right-click the specific catalog to
populate.
- Click Start Full Population
4. See whether the data had been updated
- right-click the specific catalog to review.
- Click Properties, and then click the Status, Tables, and Schedules tabs,
as appropriate.
See the following chapter in Books Online or MSDN Online for more detailed
information
Creating and Maintaining Databases -> Full-Text Indexes ->
Administering Full-Text Features Using SQL Enterprise Manager
Hope this helps and please feel free to let me know whether it works or you
need furhter help. Thank you for your patience and corporation.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||I reposted the question in news:microsoft.public.sqlserver.programming and
received a reply from Mr. Kane who point dme to a KB that while completely
unrelated showed me where to find the Auditiong options for SQL Server which
I used to pinpoint the real problem. The problem has been resolved.
""Michael Cheng [MSFT]"" wrote:
> Hi,
> Thanks for your post.
> From your descriptions, I understood that you would like to know whether
> Full-Text Search is support in SQL Server Dev Edition and how to implement
> it. Have I understood you? Correct me if I was wrong.
> Based on my scope, Full-Text Search is supported in SQL Server 2000 Dev
> Edition on Windows XP Pro. See more deatiled descritption about this in the
> following links
> Features Supported by the Editions of SQL Server 2000
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
> ar_ts_1cdv.asp
> For the second question, I am not sure your detailed steps on how to
> implement the Full-Text Search for the Table, would you please give me more
> detail information about doing so? Here is an sample doing this with SQL
> Server Enterprise Manager.
> 1. enable a table for full-text indexing
> - Expand Databases, expand the database in which the table belongs, and
> then click Tables.
> - In the details pane, right-click the table, click Full-Text Index Table,
> and then click Define Full-Text Indexing on a Table.
> 2. To create a full-text catalog
> - right-click the database where you want the full-text catalog.
> - Click New, and then click New Full-Text Catalog.
> - Complete the New Full-Text Catalog dialog box.
> 3. Make a Full Populating
> - expand the database that contains the full-text catalog to rebuild.
> - Click Full-Text Catalogs, and then right-click the specific catalog to
> populate.
> - Click Start Full Population
> 4. See whether the data had been updated
> - right-click the specific catalog to review.
> - Click Properties, and then click the Status, Tables, and Schedules tabs,
> as appropriate.
> See the following chapter in Books Online or MSDN Online for more detailed
> information
> Creating and Maintaining Databases -> Full-Text Indexes ->
> Administering Full-Text Features Using SQL Enterprise Manager
> Hope this helps and please feel free to let me know whether it works or you
> need furhter help. Thank you for your patience and corporation.
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>|||Hi,
I have noticed that thread, it's great to hear that it was resolved and
thanks for letting me know about that:)
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Full Text Indexing on Microsoft SQL Server 2000 with Windows XP Pro

I am wondering if FUll Text Indexing is suported with MS SQL Server 2000
Developer Edition on XP Pro SP2 . I have the service installed and setup. I
have created several catalogs with data but when they are done populating
they show up with an Item Count of 0 and a Unique Index of 1 despite the
fact that there are 10+ records with extremely different data in the 3
columns that are being indexed.
I am not seeing any unusual messages in the Event Viewer also. I have
uninstalled and reinstalled already and the Server is running under an
Administrator UserHi,
Thanks for your post.
From your descriptions, I understood that you would like to know whether
Full-Text Search is support in SQL Server Dev Edition and how to implement
it. Have I understood you? Correct me if I was wrong.
Based on my scope, Full-Text Search is supported in SQL Server 2000 Dev
Edition on Windows XP Pro. See more deatiled descritption about this in the
following links
Features Supported by the Editions of SQL Server 2000
http://msdn.microsoft.com/library/d...-us/architec/8_
ar_ts_1cdv.asp
For the second question, I am not sure your detailed steps on how to
implement the Full-Text Search for the Table, would you please give me more
detail information about doing so? Here is an sample doing this with SQL
Server Enterprise Manager.
1. enable a table for full-text indexing
- Expand Databases, expand the database in which the table belongs, and
then click Tables.
- In the details pane, right-click the table, click Full-Text Index Table,
and then click Define Full-Text Indexing on a Table.
2. To create a full-text catalog
- right-click the database where you want the full-text catalog.
- Click New, and then click New Full-Text Catalog.
- Complete the New Full-Text Catalog dialog box.
3. Make a Full Populating
- expand the database that contains the full-text catalog to rebuild.
- Click Full-Text Catalogs, and then right-click the specific catalog to
populate.
- Click Start Full Population
4. See whether the data had been updated
- right-click the specific catalog to review.
- Click Properties, and then click the Status, Tables, and Schedules tabs,
as appropriate.
See the following chapter in Books Online or MSDN Online for more detailed
information
Creating and Maintaining Databases -> Full-Text Indexes ->
Administering Full-Text Features Using SQL Enterprise Manager
Hope this helps and please feel free to let me know whether it works or you
need furhter help. Thank you for your patience and corporation.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

FULL TEXT INDEXING is grayed out-- Is it O/S prob?

My OS is Windows XP Professional 2002, when i'm trying to install the
Server Components for the FULL TEXT INDEXING using the SQL Server
Standard Edition CD, prior to the installation it is giving a message
saying "Microsoft SQL Server 2000 Standard Edition server component is
not supported on this operating system. only client components will be
available for instatllation"
and when i proceed further the "Upgrade, remove or add components to
the SQL Server is grayed out" where as my friend having the same OS and
same SQL Server Edition can add the Service "Microsoft Search Service"
and "Full Text Indexing".
I tried many options but nothing is working out?
what am I suppose to do now ?
can anybody help please?
Thanks in Advance
--@.@.version
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 2)
Have a look at this - http://www.indexserverfaq.com/tablenotenabled.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"savvy" <johngera@.gmail.com> wrote in message
news:1138275125.260804.40060@.g47g2000cwa.googlegro ups.com...
> My OS is Windows XP Professional 2002, when i'm trying to install the
> Server Components for the FULL TEXT INDEXING using the SQL Server
> Standard Edition CD, prior to the installation it is giving a message
> saying "Microsoft SQL Server 2000 Standard Edition server component is
> not supported on this operating system. only client components will be
> available for instatllation"
> and when i proceed further the "Upgrade, remove or add components to
> the SQL Server is grayed out" where as my friend having the same OS and
> same SQL Server Edition can add the Service "Microsoft Search Service"
> and "Full Text Indexing".
> I tried many options but nothing is working out?
> what am I suppose to do now ?
> can anybody help please?
> Thanks in Advance
> --@.@.version
> 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 2)
>

Full text help.. anyone?

Can anyone explain me how to configure full text to run on
a windows 2003 cluster (2 machines 1 sql node)?
Claudia,
Sorry for the late reply, however, assuming you're installing SQL Server
2000 Enterprise Edition on Windows 2003 Advance or Enterprise servers, Full
Text Search is installed by default. If you're using SQL Server 7.0, then
Full-Text Search is not supported in a clustered environment. Without more
info on what you're looking for, a series of steps, or troubleshooting a
specific error, it's kinda hard to provide relevant info. However, the below
KB articles should give you a good starting point...
KB Articles:
817301 PRB: Microsoft Search Full-Text Catalog Population Fails When You
Upgrade SQL Server 2000 Failover Cluster to SQL Server 2000 Service Pack 3
http://support.microsoft.com/default...&Product=sql2k
812666 How to recover a failed full-text search resource on a clustered
instance of SQL Server 2000
http://support.microsoft.com/default...&Product=sql2k
304282 (Q304282) PRB: Full Text Resource Fails to Come Online on a Cluster
with "Event ID 1069 :SQL Cluster Resource 'Full Text' failed" Error Message
http://support.microsoft.com/default...&Product=sql2k
296890 (Q296890) PRB: SQL Server 2000 Fails to Install on a Cluster If
Service Startup Account Contains a Space
http://support.microsoft.com/default...&Product=sql2k
810056 INF: You Must Use Resource-Specific Registry Keys for SQL Server
Cluster Resources
http://support.microsoft.com/default...&Product=sql2k
295732 INF: Creating Databases or Changing Disk File Locations on a Shared
Cluster Drive on Which SQL Server 2000 was not Originally Installed
http://support.microsoft.com/default...&Product=sql2k
260758 INF: Frequently Asked Questions - SQL Server 2000 - Failover
Clustering
http://support.microsoft.com/default...&Product=sql2k
814035 FIX: A Full-Text Population Fails After You Apply SQL Server 2000
Service Pack 3
http://support.microsoft.com/default...&Product=sql2k
811168 INF: SQL Server 2000 Service Pack 3 or Service Pack 3a
Pre-Installation Checklist for SQL Server 2000 Virtual Server for Failover
Clustering
http://support.microsoft.com/default...&Product=sql2k
243218 Installation order for SQL Server 2000 Enterprise Edition on
Microsoft Cluster Server
http://support.microsoft.com/default...&Product=sql2k
Regards,
John
"Claudia" <anonymous@.discussions.microsoft.com> wrote in message
news:2fbc101c46da9$5bedfac0$a401280a@.phx.gbl...
> Can anyone explain me how to configure full text to run on
> a windows 2003 cluster (2 machines 1 sql node)?
>

Full Text hangs Enterprice manager

hi,

I am using MS SQL Server 2000 SP3a on windows server 2000.

I have 4 FT indexs on 4 of my tables.
They are schedules to run every day once. For the last couple of days the jobs are hanged.

When I tried to open Catalogs by clicking on 'Full Text Catalogs' enterprice manager hangs( not responding). I had to go to taskmanager and then click on end task to re-open the enterprise manager.

Also when I right click on one of the tables enabled with FT indexing
Enterprise manager hangs up again.

If I cannt open FTCatalogs how can I rebuild them.

please respond,
mpkcontd..to my previous post

Also in my ErrorLog file i see the following messages,

2007-03-30 06:20:04.08 spid56 WARNING: EC 237815d8, 0 waited 187500 sec. on latch ad8c88. Not a BUF latch.
2007-03-30 06:20:04.08 spid56 Waiting for type 0x4, current count 0xa, current owning EC 0x59E49550.

thanx in adv,
mpk|||you can try rebuilding them using t-sql. see books online for syntax.|||Are you trying to do this while the database is not in single user mode...sorry, never have done full text myself

Full Text Catalog Search

Hello,
I'm running SQL Server 2000 on Windows 2000 Server.
I created a full text catalog of a table and one column from the table. I'm getting unexpected results when I query the catalog. The table name is "doc" and the column name is docident. I store document identification numbers in the docident column. A
mong others there are three document numbers in the docident column:
AF373416
AF373416A
AF373416C
When I run the following query for AF373416 I am returned results for both AF373416 and AF373416A. I don't see results for AF373416C though.
SELECT docident FROM doc
WHERE CONTAINS(docident,'AF373416')
Is this a bug in SQL server oris my select statement incorrect?
Thanks,
Fred Mitchell
Hi,
Can you do a incremental population of the full-text index for the
particular table.
sp_fulltext_table 'doc','start_incremental','CATALOG_NAME',NULL
Replace the catalog_name with yours.
Try executing the same query, if you still have issues then execute te below
command and try doing a select
exec sp_fulltext_catalog 'myCatalog', 'start_full'
Starts a full population for fulltext_catalog_name. Every row of every table
associated with this full-text catalog is
--retrieved for full-text indexing, even if indexed.
Thanks
Hari
MCDBA
"Fred Mitchell" <Fred Mitchell@.discussions.microsoft.com> wrote in message
news:52E4B821-3A00-42AB-9D4B-38BB38D20E13@.microsoft.com...
> Hello,
> I'm running SQL Server 2000 on Windows 2000 Server.
> I created a full text catalog of a table and one column from the table.
I'm getting unexpected results when I query the catalog. The table name is
"doc" and the column name is docident. I store document identification
numbers in the docident column. Among others there are three document
numbers in the docident column:
> AF373416
> AF373416A
> AF373416C
> When I run the following query for AF373416 I am returned results for both
AF373416 and AF373416A. I don't see results for AF373416C though.
> SELECT docident FROM doc
> WHERE CONTAINS(docident,'AF373416')
> Is this a bug in SQL server oris my select statement incorrect?
> Thanks,
> Fred Mitchell

Full Text Catalog Search

Hello,
I'm running SQL Server 2000 on Windows 2000 Server.
I created a full text catalog of a table and one column from the table. I'm getting unexpected results when I query the catalog. The table name is "doc" and the column name is docident. I store document identification numbers in the docident column. Among others there are three document numbers in the docident column:
AF373416
AF373416A
AF373416C
When I run the following query for AF373416 I am returned results for both AF373416 and AF373416A. I don't see results for AF373416C though.
SELECT docident FROM doc
WHERE CONTAINS(docident,'AF373416')
Is this a bug in SQL server oris my select statement incorrect?
Thanks,
Fred MitchellHi,
Can you do a incremental population of the full-text index for the
particular table.
sp_fulltext_table 'doc','start_incremental','CATALOG_NAME',NULL
Replace the catalog_name with yours.
Try executing the same query, if you still have issues then execute te below
command and try doing a select
exec sp_fulltext_catalog 'myCatalog', 'start_full'
Starts a full population for fulltext_catalog_name. Every row of every table
associated with this full-text catalog is
--retrieved for full-text indexing, even if indexed.
Thanks
Hari
MCDBA
"Fred Mitchell" <Fred Mitchell@.discussions.microsoft.com> wrote in message
news:52E4B821-3A00-42AB-9D4B-38BB38D20E13@.microsoft.com...
> Hello,
> I'm running SQL Server 2000 on Windows 2000 Server.
> I created a full text catalog of a table and one column from the table.
I'm getting unexpected results when I query the catalog. The table name is
"doc" and the column name is docident. I store document identification
numbers in the docident column. Among others there are three document
numbers in the docident column:
> AF373416
> AF373416A
> AF373416C
> When I run the following query for AF373416 I am returned results for both
AF373416 and AF373416A. I don't see results for AF373416C though.
> SELECT docident FROM doc
> WHERE CONTAINS(docident,'AF373416')
> Is this a bug in SQL server oris my select statement incorrect?
> Thanks,
> Fred Mitchell

Full Text Catalog Search

Hello,
I'm running SQL Server 2000 on Windows 2000 Server.
I created a full text catalog of a table and one column from the table. I'm
getting unexpected results when I query the catalog. The table name is "do
c" and the column name is docident. I store document identification numbers
in the docident column. A
mong others there are three document numbers in the docident column:
AF373416
AF373416A
AF373416C
When I run the following query for AF373416 I am returned results for both A
F373416 and AF373416A. I don't see results for AF373416C though.
SELECT docident FROM doc
WHERE CONTAINS(docident,'AF373416')
Is this a bug in SQL server oris my select statement incorrect?
Thanks,
Fred MitchellHi,
Can you do a incremental population of the full-text index for the
particular table.
sp_fulltext_table 'doc','start_incremental','CATALOG_NAME'
,NULL
Replace the catalog_name with yours.
Try executing the same query, if you still have issues then execute te below
command and try doing a select
exec sp_fulltext_catalog 'myCatalog', 'start_full'
Starts a full population for fulltext_catalog_name. Every row of every table
associated with this full-text catalog is
--retrieved for full-text indexing, even if indexed.
Thanks
Hari
MCDBA
"Fred Mitchell" <Fred Mitchell@.discussions.microsoft.com> wrote in message
news:52E4B821-3A00-42AB-9D4B-38BB38D20E13@.microsoft.com...
> Hello,
> I'm running SQL Server 2000 on Windows 2000 Server.
> I created a full text catalog of a table and one column from the table.
I'm getting unexpected results when I query the catalog. The table name is
"doc" and the column name is docident. I store document identification
numbers in the docident column. Among others there are three document
numbers in the docident column:
> AF373416
> AF373416A
> AF373416C
> When I run the following query for AF373416 I am returned results for both
AF373416 and AF373416A. I don't see results for AF373416C though.
> SELECT docident FROM doc
> WHERE CONTAINS(docident,'AF373416')
> Is this a bug in SQL server oris my select statement incorrect?
> Thanks,
> Fred Mitchell

Full Text Catalog Search

Hello,
I'm running SQL Server 2000 on Windows 2000 Server.
I created a full text catalog of a table and one column from the table. I'm getting unexpected results when I query the catalog. The table name is "doc" and the column name is docident. I store document identification numbers in the docident column. A
mong others there are three document numbers in the docident column:
AF373416
AF373416A
AF373416C
When I run the following query for AF373416 I am returned results for both AF373416 and AF373416A. I don't see results for AF373416C though.
SELECT docident FROM doc
WHERE CONTAINS(docident,'AF373416')
Is this a bug in SQL server oris my select statement incorrect?
Thanks,
Fred Mitchell
Fred,
First of all, thank you for providing your SQL Server version and OS
Platform info! The latter is most important, and depending upon the actual
data, including punctuation, you may indeed be hitting a bug, not in SQL
Server, but with the OS supplied wordbreaker dll, Win2K's infosoft.dll.
Specifically, if there is any punctuation characters that is actual in
contact with your search word (AF373416), and if you are using the default
US_English "Language for Word Breaker", then the punctuation character is FT
Indexed along with the search word. Specifically, could you provide an
actual sample of the data in the docident column?
The current workaround for this issue on Win2K, is to drop and re-create the
FT Catalog and use the Neutral "Language for Word Breaker" and then run a
Full Population and re-test your below FTS query. Note, this is not an issue
with Win2003 or WinXP as these OS platforms have a new OS supplied
wordbreaker, langwrkb.dll.
Regards,
John
"Fred Michael" <FredMichael@.discussions.microsoft.com> wrote in message
news:1439C10B-1C0A-4592-BEBF-1C62C8F71620@.microsoft.com...
> Hello,
> I'm running SQL Server 2000 on Windows 2000 Server.
> I created a full text catalog of a table and one column from the table.
I'm getting unexpected results when I query the catalog. The table name is
"doc" and the column name is docident. I store document identification
numbers in the docident column. Among others there are three document
numbers in the docident column:
> AF373416
> AF373416A
> AF373416C
> When I run the following query for AF373416 I am returned results for both
AF373416 and AF373416A. I don't see results for AF373416C though.
> SELECT docident FROM doc
> WHERE CONTAINS(docident,'AF373416')
> Is this a bug in SQL server oris my select statement incorrect?
> Thanks,
> Fred Mitchell
>