开发者

Cannot create a stop list in SQl 2008

I'm new to the st开发者_开发技巧op list functionality in SQL 2008 and seem to be missing something obvious. I'm trying to exectue the following statement:

CREATE FULLTEXT STOPLIST myStoplist3  
FROM SYSTEM STOPLIST;  
GO  

and I'm getting the following error:

Msg 102, Level 15, State 1, Line 1  
Incorrect syntax near 'STOPLIST'.  

Any ideas? The code is lifted straight out of MSDN so I'm assuming it's a configuration issue - full text search is set up and working.


Probably stating the obvious here but make sure the compatibility level for you database is set to 100 (SQL 2008) as well. Just in case its been set for 90 (SQL 2005) or lower.


Your syntax is fine - how are you executing the statement? Because if you're executing it from code then you need to remove the 'GO', as GO is not a SQL Keyword, it's a special token that is interpreted by client applications (e.g. management studio) to mean 'now send this batch to the server'.


Are you sure you have the appropriate permissions to create fulltext indices?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜