Microsoft SQL Server 2008 includes a complete set of tools and command prompt utilities that allow users, programmers, and administrators to:

* Administer and configure SQL Server.

* Determine the catalog information in a copy of SQL Server.

* Design and test queries for retrieving data.

* Copy, import, export, and transform data.

* Provide diagnostic information.

* Start and stop SQL Server.

Command prompt – CMD – utilities that come with Microsoft SQL Server

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. <drive>:Program FilesMicrosoft SQL Server100ToolsBinn
dta Utility Used to analyze a workload and recommend physical design structures to optimize server performance for that workload. <drive>:Program FilesMicrosoft SQL Server100ToolsBinn
dtexec Utility (SSIS Tool) Used to configure and execute an Integration Services package. A user interface version of this command prompt utility is called DTExecUI, which brings up the Execute Package Utility. <drive>:Program FilesMicrosoft SQL Server100DTSBinn
dtutil Utility (SSIS Tool) Used to manage SSIS packages. <drive>:Program FilesMicrosoft SQL Server100DTSBinn
Deployment Utility (Analysis Services – Multidimensional Data) Used to deploy Analysis Services projects to instances of Analysis Services. <drive>:Program FilesMicrosoft SQL Server100ToolsBinnVShellCommon7IDE
osql Utility Allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt. <drive>:Program FilesMicrosoft SQL Server100ToolsBinn
Profiler Utility Used to start SQL Server Profiler from a command prompt. <drive>:Program FilesMicrosoft SQL Server100ToolsBinn
rs Utility Used to run scripts designed for managing Reporting Services report servers. <drive>:Program FilesMicrosoft SQL Server100ToolsBinn
rsconfig Utility Used to configure a report server connection. <drive>:Program FilesMicrosoft SQL Server100ToolsBinn
rskeymgmt Utility Used to manage encryption keys on a report server. <drive>:Program FilesMicrosoft SQL Server100ToolsBinn
sqlagent90 Application Used to start SQL Server Agent from a command prompt. x:Program FilesMicrosoft SQL Server<instance_name>MSSQLBinn
sqlcmd Utility Allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt. <drive>:Program FilesMicrosoft SQL Server100ToolsBinn
SQLdiag Utility Used to collect diagnostic information for Microsoft Customer Service and Support. <drive>:Program FilesMicrosoft SQL Server100ToolsBinn
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. <drive>:Program FilesMicrosoft SQL Server100ToolsBinn
sqlmaint Utility Used to execute database maintenance plans created in previous versions of SQL Server. x:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBinn
sqlps Utility Used to run PowerShell commands and scripts. Loads and registers the SQL Server PowerShell provider and cmdlets. <drive>:Program FilesMicrosoft SQL Server100ToolsBinn
sqlservr Application Used to start and stop an instance of Database Engine from the command prompt for troubleshooting. x:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBinn
Ssms Utility Used to start SQL Server Management Studio from a command prompt. <drive>:Program FilesMicrosoft SQL Server100ToolsBinnVSShellCommon7IDE
tablediff Utility Used to compare the data in two tables for non-convergence, which is useful when troubleshooting a replication topology. <drive>:Program FilesMicrosoft SQL Server100COM

Any comments will be learning point.