Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Cannot create a stop list in SQl 2008

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.

like image 526
Andrew Hancox Avatar asked Feb 09 '10 11:02

Andrew Hancox


People also ask

What causes SQL error?

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.

What is FULLTEXT stoplist?

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.

What is Stoplist in SQL Server?

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.

What is SQL error number?

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.


1 Answers

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.

like image 174
kevchadders Avatar answered Oct 15 '22 10:10

kevchadders