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 launched from SQL Server Enterprise Manager. Use the Full-Text Indexing Wizard to define full-text indexing on Microsoft® SQL Server™ 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] [/sserver_name] [/ulogin_id] [/ppassword] [/ddatabase_name]

Arguments

/n

Specifies that SQL Server uses Windows NT Authentication Mode (not required).

/sserver_name

Specifies the name of the server running SQL Server whose tables are to be full-text indexed. If server_name is not specified, the default local server is selected.

/ulogin_id

Specifies the login ID used to connect to SQL Server. Either Windows NT Authentication (with or without a Microsoft Windows NT® login ID and password) or a SQL Server login ID and password must be supplied.

/ppassword

Specifies the password for the given login_id.

/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 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.

Examples

This example runs the sqlftwiz utility against the Northwind database on a server named MyServer.

sqlftwiz /sMyServer /usa /ppassword /dNorthwind

See Also