FULLTEXT INDEX SCRIPTING - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

FULLTEXT INDEX SCRIPTING

Author

Topic

chava_sree
Yak Posting Veteran

56 Posts

Posted - 2008-07-23 : 14:10:39

Guys,

Does anybody know how to Generate Scripts for the FullText Index Catalogues, I am able to generate script for fulltext (Creation) but not the INDEXES attached to it.. i used SQL MANAGEMENT STUDIO ..USER INTERFACE to create and now i want to implement these in multiple servers like staging/live server etc..

any ideas..or help is much appreciated.. am stuck at this point and unable to move forward.

thanks

dshelton
Yak Posting Veteran

73 Posts

Posted - 2008-07-24 : 01:20:50

If there is no Generate Script option, you could always write the script.
BOL example below:

USE AdventureWorks;
GO
CREATE FULLTEXT CATALOG ftCatalog AS DEFAULT;
GO
CREATE FULLTEXT INDEX ON HumanResources.JobCandidate(Resume) KEY INDEX ui_ukJobCand;
GO

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources