sqlftwiz Utility
The sqlftwiz utility allows the Full-Text Indexing Wizard to be executed using a command prompt utility. The Full-Text Indexing Wizard can also be started from SQL Server Enterprise Manager. Use the Full-Text Indexing Wizard to define full-text indexing on Microsoft® SQL Server™ 2000 text-based columns with either an existing full-text catalog, or a new full-text catalog. The Full-Text Indexing Wizard also creates or modifies population schedules that determine when the information stored in the full-text catalog is updated.
Syntax
sqlftwiz
{/n | {/ulogin_id /ppassword}}
[/sserver_name[\instance_name]]
[/ddatabase_name]
Arguments
/n
Specifies Windows Authentication Mode (password not required).
/ulogin_id
Specifies the login ID used to connect to an instance of SQL Server 2000.
/ppassword
Specifies the password for the given login_id.
/sserver_name[\instance_name]
Specifies the instance of SQL Server 2000 whose tables are to be full-text indexed. Specify server_name to connect to the default instance of SQL Server 2000 on that server. Specify server_name\instance_name to connect to a named instance of SQL Server 2000 on that server. If no server is specified, sqlftwiz connects to the default instance of SQL Server 2000 on the local computer.
/ddatabase_name
Specifies the database name of the SQL Server database whose tables are to be full-text indexed. If database_name is not specified, SQL Server 2000 prompts for the selection of a database_name on the given server_name.
Remarks
There must be no space between a switch and its corresponding value.
For information about where to find or how to run this utility, see Getting Started with Command Prompt Utilities.
Examples
This example runs the sqlftwiz utility against the Northwind database on a server named MyServer.
sqlftwiz /sMyServer /n /dNorthwind