Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sqlftwiz Utility

SQL Server 2000

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.

Show:
© 2015 Microsoft