I think I figured out the issue of creating the stop list . When I run:

select * from sys.databases where name = 'dbname'

The compatibility_level is 80 but...

Thanks for the info. That is a great reply.

If I run the following shouldn't I see a row with 'name' having the value of 7? I...

Yes, it returns results.

SELECT p.product_id, p.product_name, p.product_sml_img, p.product_size, isnull(pti.pti_image, '''') as product_type_image, fnCreateProductURL_New(product_id,null) as product_url

FROM product p

...

No, that means my sql would be

SELECT *

FROM <table>

ORDER by <field>, <ASC|DESC>

That doesn't look right to me.

so what's the standard for creating a searchable site? Do you just hope the user enters a full word? Or do you keep doing the like with...

I am just trying to do the equivalent to the LIKE as I have above but using the full-text index.

I am trying to do a search on my site but...

there is no index on qm_entry_dt

Yeah, I don't think it's working. I had the admin restart the server and still getting the errors in the log. My log file is closing in on 1...

SELECT @@VERSION

Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build...

It appears to be working because my log file is up to 83,251 KB in like 20 minutes since I created it and all that is in it is the...

I removed the index and recreated.

Looking at files I noticed in

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG a file SQLFT0000900006.LOG which is 3,851 KB.

Here are the last few logs but I...

Size of C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\FT_USERS? is: 288 KB

% Idle Time: around 97

Should I delete the fulltext index and try it again?

Is the best way to remove it...

In C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\FT_USERS I have 1 file and 1 folder and within the 1 folder are only a handful of files all with date modified on 2/12/2011

MssearchCatalogDir

-CiAB0001.000

-CiAB0001.001

-CiAB0001.002

-CiAB0002.000

-CiAB0002.001

-CiAB0002.002

-CiAD0001.000

-CiAD0001.001

-CiAD0001.002

-CiPT0000.000

-CiPT0000.001

-CiPT0000.002

-INDEX.000

-INDEX.001

-INDEX.002

-SETTINGS.DIA

-Used0000.000

-USed0000.001

-Used0000.002

SQL.HDR

Of the...

I don't think anything related to the index is running. I have a process run twice a day that does inserts/updates.

How does it get activated?...

Is there a way to tell if it's setup properly? According to these it doesn't look like it's populating properly.

select fulltextcatalogproperty('FT_USERS', 'PopulateStatus')

--RESULT: 1

select fulltextcatalogproperty('FT_USERS', 'ItemCount')

--RESULT: 0

select fulltextcatalogproperty('FT_USERS', 'LogSize')

--RESULT: 0

select...