sql server full text search: How to generate full-texting setting script for porting to another SQL
Server?

Right click on your table in Enterprise Manager, select All Tasks and
Generate SQL Script. Click on show all and select any additional tables you
with to script. In the options tab select script full text indexes. Then
click on preview (in the general tab) or click on OK.

In the resultant script you will have the full-text index creation commands
(delete the table script stuff) . You should be able to run this on your
other server.

--
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
[quoted text, click to view]

ABC,
This is easy to gather either via the Enterprise Manager (EM) and script out
the necessary code, or you can use the Profiler to trace the events that the
EM is doing, see the following blog entry for details:

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

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


[quoted text, click to view]