Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    32

    Unanswered: Full text indexing

    I'd like to incrmentally populate my products full text catalogue everytime a product is added, i'm using the following code:

    exec msdb.dbo.sp_fulltext_catalog [ @ftcat = ] 'Products'
    , [ @action = ] 'start_incremental'
    [ , [ @path = ] 'C:\Program Files\Microsoft SQL Server\Mssql\Ftdata' ]

    I get the syntax error Line 166: Line 166: Incorrect syntax near 'Products'.

    what is wrong with the code? Any help would be appreciated

  2. #2
    Join Date
    Jul 2004
    Posts
    32
    Well I got rid of the [] brackets and it seems to work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •