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.

sqlftwiz /sMyServer /n /dNorthwind