Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
Dear forum mediators, as a beginner to SQL server, I have learned that I can't use master database to conduct full-text search. I should use the test database instead. This question might be a good reference for the beginners who want to learn about full-text search using SQL server 2012. –  user2061466 Jan 15 at 2:46
add comment

closed as off-topic by Mark Storey-Smith, Kin, Max Vernon, Paul White, ypercube Jan 2 at 20:08

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Mark Storey-Smith, Kin, Max Vernon, Paul White, ypercube
If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers

You're using master. Like the error message says, you can't do that in master. Try using the TSQL2012 database.

share|improve this answer
1  
Hello Katherine thanks for the reply. I used the database TSQL2012 to create the SQLStopList. It worked. I didn't receive any error message. –  user2061466 Dec 31 '13 at 4:09
add comment
"...Cannot use full-text search in master, tempdb, or model database."

You just can't use the master, tempdb or model database for full-text search.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.