Command Prompt Utilities

The following table contains a list of command prompt utilities that ship with Microsoft SQL Server 2005.

Utility Description Installed in

bcp Utility

Used to copy data between an instance of Microsoft SQL Server and a data file in a user-specified format.

x:\Program Files\Microsoft SQL Server\90\Tools\Binn

dta Utility

Used to analyze a workload and recommend physical design structures to optimize server performance for that workload.

x:\Program Files\Microsoft SQL Server\90\Tools\Binn

dtexec Utility

Used to configure and execute a SQL Server 2005 Integration Services (SSIS) (SSIS) package. A user interface version of this command prompt utility is called DTExecUI, which brings up the Execute Package Utility.

x:\Program Files\Microsoft SQL Server\90\DTS\Binn

dtutil Utility

Used to manage SSIS packages.

x:\Program Files\Microsoft SQL Server\90\DTS\Binn

Microsoft.AnalysisServices.Deployment Utility

Used to deploy Analysis Services projects to instances of Analysis Services.

x:\Program Files\Microsoft SQL Server\90\Tools\Binn\VShell\Common7\IDE

nscontrol Utility

Used to create, delete, and manage instances of Notification Services.

x:\Program Files\Microsoft SQL Server\90\NotificationServices\n.n.nnn\bin

osql Utility

Allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt.

x:\Program Files\Microsoft SQL Server\90\Tools\Binn

profiler90 Utility

Used to start SQL Server Profiler from a command prompt.

x:\Program Files\Microsoft SQL Server\90\Tools\Binn

rs Utility

Used to run scripts designed for managing Reporting Services report servers.

x:\Program Files\Microsoft SQL Server\90\Tools\Binn

rsconfig Utility

Used to configure a report server connection.

x:\Program Files\Microsoft SQL Server\90\Tools\Binn

rskeymgmt Utility

Used to manage encryption keys on a report server.

x:\Program Files\Microsoft SQL Server\90\Tools\Binn

sac Utility

Used to import or export surface area configuration settings between instances of SQL Server 2005.

x:\Program Files\Microsoft SQL Server\90\Shared

sqlagent90 Application

Used to start SQL Server Agent from a command prompt.

x:\Program Files\Microsoft SQL Server\<instance_name>\MSSQL\Binn

sqlcmd Utility

Allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt.

x:\Program Files\Microsoft SQL Server\90\Tools\Binn

SQLdiag Utility

Used to collect diagnostic information for Microsoft Customer Service and Support.

x:\Program Files\Microsoft SQL Server\90\Tools\Binn

sqllogship Application

Used by applications to perform backup, copy, and restore operations and associated clean-up tasks for a log shipping configuration without running the backup, copy, and restore jobs.

x:\Program Files\Microsoft SQL Server\90\Tools\Binn

sqlmaint Utility

Used to execute database maintenance plans created in previous versions of SQL Server.

x:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn

sqlservr Application

Used to start and stop an instance of Database Engine from the command prompt for troubleshooting.

x:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn

sqlwb Utility

Used to start SQL Server Management Studio from a command prompt.

x:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE

tablediff Utility

Used to compare the data in two tables for non-convergence, which is useful when troubleshooting a replication topology.

x:\Program Files\Microsoft SQL Server\90\COM

Command Prompt Utilities Syntax Conventions

Convention Used for

UPPERCASE

Statements and terms used at the operating system level.

monospace

Sample commands and program code.

italic

User-supplied parameters.

bold

Commands, parameters, and other syntax that must be typed exactly as shown.

See Also

Other Resources

Replication Distribution Agent
Replication Log Reader Agent
Replication Merge Agent
Replication Queue Reader Agent
Replication Snapshot Agent

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

17 July 2006

Changed content:
  • Changed the installed-in path for the Microsoft.AnalysisServices.Deployment utility.