Full-text Catalog

21 Oct 2005 2:39 PM

bob

I am have an application that uses a full-text catalog for word searching.
I need to dsitribute this application so is there a way to distribute the
full-text catalog with a script like I do for the database, sp's and
triggers?

Thanks

21 Oct 2005 11:39 PM

Jerry Spivey

Bob,

See:

'Example of Combining Full-text Administration and Full-text Query' in the
SQL BOL.

HTH

Jerry
Show quote

"bob" <bo***@bob.com> wrote in message
news:Oirxi3k1FHA.916@TK2MSFTNGP10.phx.gbl...
>I am have an application that uses a full-text catalog for word searching.
>I need to dsitribute this application so is there a way to distribute the
>full-text catalog with a script like I do for the database, sp's and
>triggers?
>
> Thanks
>

23 Oct 2005 1:43 AM

John Kane

Bob,
In addition to the BOL title that Jerry suggested, you should also be able
to use the SQL code examples in KB Article 240867 "How to move, copy, and
back up full-text catalog folders and files" at
http://support.microsoft.com/?kbid=240867 to help you do this too.
Additionally, you can use the Enterprise Manager and script out the SQL code
or use Profiler to trace what the FT Indexing wizard is doing, for the
latter see:

Full Text Indexing using T-SQL from a Profiler Trace
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!304.entry

Enjoy!
John

--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

Show quote

"Jerry Spivey" <jspi***@vestas-awt.com> wrote in message
news:uXdzfip1FHA.980@TK2MSFTNGP14.phx.gbl...
> Bob,
>
> See:
>
> 'Example of Combining Full-text Administration and Full-text Query' in the
> SQL BOL.
>
> HTH
>
> Jerry
> "bob" <bo***@bob.com> wrote in message
> news:Oirxi3k1FHA.916@TK2MSFTNGP10.phx.gbl...
>>I am have an application that uses a full-text catalog for word searching.
>>I need to dsitribute this application so is there a way to distribute the
>>full-text catalog with a script like I do for the database, sp's and
>>triggers?
>>
>> Thanks
>>
>
>