Export (0) Print
Expand All
8 out of 20 rated this helpful - Rate this topic

Command Prompt Utilities

Updated: 17 July 2006

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

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.

Release History

17 July 2006

Changed content:
  • Changed the installed-in path for the Microsoft.AnalysisServices.Deployment utility.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.