Forum Replies Created

Viewing 15 posts - 1 through 15 (of 25 total)

  • RE: CONTAINS showing results when shouldn't

    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...

  • RE: CONTAINS showing results when shouldn't

    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...

  • RE: sp_executesql issue

    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

    ...

  • RE: sp_executesql issue

    No, that means my sql would be

    SELECT *

    FROM <table>

    ORDER by <field>, <ASC|DESC>

    That doesn't look right to me.

  • RE: full-text indexing with partical word

    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...

  • RE: full-text indexing with partical word

    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...

  • RE: function vs straight query response time

    there is no index on qm_entry_dt

  • RE: Creating full-text indexing on table

    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...

  • RE: Creating full-text indexing on table

    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...

  • RE: Creating full-text indexing on table

    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...

  • RE: Creating full-text indexing on table

    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...

  • RE: Creating full-text indexing on table

    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...

  • RE: Creating full-text indexing on table

    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...

  • RE: Creating full-text indexing on table

    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?...

  • RE: Creating full-text indexing on table

    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...

Viewing 15 posts - 1 through 15 (of 25 total)