John

May 24, 2001

Yep, I'm back.

I've got a development server running SQL Server 7. For some reason, the full-text indexes absolutely refuse to populate. They claim they're repopulating, and they claim to successfully repopulate, but they're coming out blank.

We need our full text indexes, because we need to test (on said development server) some freetext-based queries before going live. (The live server doesn't seem to have this problem, but SQL Server was installed and configured with the same options on both.)

Things I've checked:

* Microsoft Search Agent is running
* The full-text indexes have been rebuilt (several times)
* This is occurring to all databases on this server
* SQLAgent is running
* MSSQLServer service is running
* System and administrator accounts have full control over FTDATA and WinntTempGHTRSVC directories.

Microsoft's Knowledge Base and online troubleshooter were of no help. (I went through every step of the online troubleshooter except messing with the registry to increase the search index size. I can't bring myself to do this on a piddly little 53-meg database -- it shouldn't be needed, especially since only a few columns of one table are being indexed!)

Anyone have any ideas?

Thanks in advance!

View 1 Replies


ADVERTISEMENT

Query To Retrieve First Names Of Person Where Last Name Is John

Dec 16, 2013

I need a query which retrives the firstnames of the person where last name is john. I am considering the performance as the main factor.

Is there any better query than the following?

Select firstname from tablename where lastname='John'

Considering performance as the major factor....

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved