2012年3月11日星期日

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 appreciatedWell I got rid of the [] brackets and it seems to work.

没有评论:

发表评论