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.
没有评论:
发表评论