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 .NET, Sql, ASP.NET, and other crazy shenanigans

News

Personal Blog

Work Blog

.NET

Book Authors

Business

Family

Friends

Georgia Tech Bloggers

Personal

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)