Saving full-text catalog to different location than default

Hi,
I am writing a database install application that will also create
full-text catalogs on specified data tables. Thanks to help I got
here, this works just fine.
I would also like to store these catalogs to a location different than
default provided by SQL Server. I can retrieve catalog name and
prompt user for a new location so far but how to store it to that
location.
How can I do that?
Thank you,
any help will be appreciated.
_dino_
sp_fulltext_catalog allows you to place it where ever you want. here is a
link describing it.
http://msdn.microsoft.com/library/de...fa-fz_1m07.asp
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dino Buljubasic" <dino@.noplacelikehome.com> wrote in message
news:ha92f1lobmt3c2qit0p7mqa3s5grid4jr1@.4ax.com...
> Hi,
> I am writing a database install application that will also create
> full-text catalogs on specified data tables. Thanks to help I got
> here, this works just fine.
> I would also like to store these catalogs to a location different than
> default provided by SQL Server. I can retrieve catalog name and
> prompt user for a new location so far but how to store it to that
> location.
> How can I do that?
> Thank you,
> any help will be appreciated.
> _dino_
|||Thank you, appreciate the help.
_dino_
On Wed, 3 Aug 2005 17:03:14 -0400, "Hilary Cotter"
<hilary.cotter@.gmail.com> wrote:

>sp_fulltext_catalog allows you to place it where ever you want. here is a
>link describing it.
>http://msdn.microsoft.com/library/de...fa-fz_1m07.asp