Getting Started with Command Prompt Utilities

The command prompt utilities are installed automatically when you install the Microsoft® SQL Server™ 2000 utilities on a computer running Microsoft Windows® 2000, Microsoft Windows NT®, Microsoft Windows 95, or Microsoft Windows 98. The table shows the utilities and the directories where they are installed.

Directory	Utilities
x:\Program Files\Microsoft SQL Server\MSSQL\Binn1	bcp2 console isql2 sqlagent sqldiag sqlmaint sqlservr vswitch
x:\Program Files\Microsoft SQL Server\80\Tools\Binn	bcp2 dtsrun dtswiz isql2 isqlw itwiz odbccmpt osql rebuildm sqlftwiz
x:\Program Files\Microsoft SQL Server\80\Com	distrib3 logread3 replmerg3 snapshot3
x:\Program Files\Common Files\Microsoft Shared\Service Manager	scm
x:\Program Files\Common Files\Microsoft Shared\???	regxmlss

1 MSSQL is the directory name for the default instance of SQL Server 2000. For each named instance of SQL Server 2000, the corresponding directory name is MSSQL$instance_name.
2 The bcp and isql utilities are installed in both the \MSSQL\Binn directory and the \80\Tools\Binn directory. They are also installed in the \MSSQL$instance_name\Binn directory for each named instance of SQL Server 2000. Any copy of these utilities may be used to connect to any instance of SQL Server. The instance of SQL Server to connect to is determined for each utility by a server argument. You are not limited to the instance of SQL Server corresponding to the directory in which the utility is run.
3 These are the file names for the four replication agent utilities.

During installation, the x:\Program Files\Microsoft SQL Server\80\Tools\Binn directory is added to the system path. You can run the utilities in this directory at any command prompt. For a utility not in the 80\Tools\Binn directory, you must either run the utility from a command prompt in the directory in which it is installed or explicitly specify the path.

These utilities are no longer installed by SQL Server 2000 Setup.

• makepipe utility
  
  
• odbcping utility
  
  
• readpipe utility

If you need to run these utilities, you can run them from the x:\x86\Binn directory on the SQL Server 2000 compact disc, or manually copy them to your computer.