Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Full Text Indexing Setup

Status
Not open for further replies.

Ovatvvon

Programmer
Feb 1, 2001
1,514
US
Hi,

When enabling Full Text Indexing on a database in SQL 2005, you can easily enough click the checkbox in the database properties GUI. But if you want to specify where on the file-system you want the FT files to reside, where do you specify that? The only place I know of is in the files tab when you're doing a restore of the database, but I can't seem to find where to do it when you initially enable it on a running DB in the GUI.



-Ovatvvon :-Q
 
Ovatvvon,
I think you specify the physical location of the catalog that the index will reside in when you create the FT index.

~LFCfan

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top