SQL Server 6.0 provides a number of utilities that enhance the capabilities of the server and ease usability. The utilities included offer either a command-line or graphical user interface and usually have a specific function. The utilities can be categorized by how they are used.
These are the utilities executed from the command-line:
| Utility program |
Executable |
Description |
| bcp* | BCP.EXE | Used for command-line transfers either to or from SQL Server and an operating-system file. |
| Check Upgrade | CHKUPG.EXE | Used by SQL Setup during an upgrade to check the compatibility of existing user-defined databases. This program can be run standalone to provide information about database keywords and possible upgrade issues. For details, see Microsoft SQL Server Setup. |
| console* | CONSOLE.EXE | Used with the Transact-SQL DUMP statement to back up databases to diskette dump devices. |
| isql* | ISQL.EXE | Allows you to enter Transact-SQL statements and system procedures from an interactive command-line prompt. It is also used to run Transact-SQL scripts. |
| Language Installation | LANGINST.EXE | Used by SQL Setup to install additional language information, such as localized messages and country information. |
| makepipe* and readpipe* | MAKEPIPE.EXE and READPIPE.EXE | Determine the validity and integrity of the network named-pipe services. Always used together. |
| Sort Order Installation | CHARSET.EXE | Used by SQL Setup to install character set and order information. |
| SQL Alerter | SQLALRTR.EXE | Used to integrate the alert engine with the Windows NT Performance Monitor alerter. For details on alert management, see the Microsoft SQL Server Administrator's Companion. |
| SQL Executive | SQLEXEC.EXE | The local administrative agent responsible for scheduling tasks (including replication), handling alerts, and monitoring SQL Server. For details, see the Microsoft SQL Server Administrator's Companion. |
| sqlservr* | SQLSERVR.EXE | The SQL Server executable itself. This program can be started from the command line with special options used for troubleshooting and/or temporarily changing SQL Server behavior. |
| * The utilities marked with an asterisk (*) may need to be run standalone. They are detailed in the following sections. |
||
These graphical utilities are provided for ease of use. Each of these utilities provides online Help. For details, start these utilities from the icon in the Microsoft SQL Server 6.0 program group in Program Manager and use the online Help system.
| Utility program | Executable | Description |
| ISQL/w | ISQLW.EXE | A graphical query tool that provides a way to analyze the plan of a query, view statistics information, and manage multiple queries in different windows simultaneously. |
| SQL Client Configuration Utility | WINDBVER.EXE | Used for managing the client configuration for DB-Library, various Net-Libraries and/or custom named pipes. |
| SQL Enterprise Manager | SQLEW.EXE | Used for complete SQL Server enterprise management, including: managing servers, databases, objects, alerts, scheduled tasks, replication and queries. |
| SQL Security Manager | SQSECMGR.EXE | Used for managing SQL Server integrated login security. |
| SQL Service Manager | SQLMGR.EXE | Used for starting, stopping, and pausing/continuing SQL Server activity. |
| SQL Setup | SETUP.EXE | Used initially for installation. Also used for upgrades, installing additional components, changing selected configuration options, and removing an installation. |
| SQL Transfer Manager | SQLXFR.EXE | Used for managing data or object transfers between Microsoft SQL Server and other SQL Server platforms to SQL Server 6.0. |