I'm new to the stop 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.
The cause of these problems can vary from file system corruption, underlying hardware system issues, driver issues, corrupted pages in memory, or problems with the SQL Server Engine.
A stoplist is a list of stopwords that, when associated with a full-text index, is applied to full-text queries on that index. For more information, see Configure and Manage Stopwords and Stoplists for Full-Text Search.
SQL Server ships with a system stoplist that contains the most commonly used stopwords for each supported language, that is for every language associated with given word breakers by default. You can copy the system stoplist and customize your copy by adding and removing stopwords.
The error number is an integer that must be a value between 50000 and 2147483647. The next parameter is the message, which is a string containing a description of the error. It's format is nvarchar(2048), and finally we have the state, which is a constant between 0 and 255.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With