Follow me on Twitter at Twitter.com/wbm
FYI, I'm blogging most of my stuff over at More Wally now.
You might want to add my rss feed to your reader at:http://morewally.com/cs/blogs/wallym/rss.aspx
Full-Text Catalogs in the master, model, or tempdb databases - Wallace B. McClure

Wallace B. McClure

All About Wally McClure - The musings of Wallym on Web, HTML5, Mobile, MonoTouch for iPhone, MonoDroid for Android, and Windows Azure.

News

Personal Blog

Work Blog

.NET

Book Authors

Business

Family

Friends

Georgia Tech Bloggers

Personal

Archives

Full-Text Catalogs in the master, model, or tempdb databases

In reading through the documentation on Sql Server 2005, it states that a full-text catalog can not be created in the master, model, or tempdb databases.  The more interesting question to me is "Why would I want to do create a catalog in those databases?"  I've always stayed out of those databases and I always thought it a good idea not to go changing things in them.

Wally

Comments

John Kane said:

While I've not *yet* tested this with SQL Server 2005 (Yukon), but with SQL Server 7.0 and 2000, you could FT-enable tempdb as well as model. Then in tempdb, you could the create and FT-enable tempdb..tablename, but not #tablename. In model, you could set the this database to FT-enabled, and when you created any new database (including tempdb), then the new database would be FT-enabled by default!

John
# January 14, 2005 9:02 AM
Leave a Comment

(required) 

(required) 

(optional)

(required)