I am doing an exercise in Microsoft 70-461 certification book (written by Itzik Ben-Gan) In chapter 6-Query Full text data. I run the following query to create a stopword list. The system showed me an error message.
Msg 9966, Level 16, State 106, Line 135 Cannot use full-text search in master, tempdb, or model database.
Here is the query I am trying to run
use master; create fulltext stoplist SQLStopList; GO alter FULLTEXT STOPLIST SQLStopList ADD 'SQL' LANGUAGE 'English';
Please give me some advises on what caused the error and how to fix it
Is there a log I can check to see what might went wrong. You advise is greatly appreciated.