Export (0) Print
Expand All
2 out of 10 rated this helpful - Rate this topic

Getting Started with Command Prompt Utilities

SQL Server 2000

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
logread
3
replmerg
3
snapshot
3
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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.